jchewsmith
Technical User
How do you change a date/time that is a weekend day to Monday at 7:00 am
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal Date Time 1
- Thread starter jchewsmith
- Start date
- Status
-
1
- #2
Try:
Hope this helps
Cheers
Pete
Code:
If DayOfWeek({Table.Field}) = 7
Then DateTime(DateSerial(Year({Table.Field}),Month({Table.Field}),Day({Table.Field})+2),Time(7,0,0))
Else
If DayOfWeek({Table.Field}) = 1
Then DateTime(DateSerial(Year({Table.Field}),Month({Table.Field}),Day({Table.Field})+1),Time(7,0,0))
Else {Table.Field}Hope this helps
Cheers
Pete
- Status