deejay_totoro
Registered User.
- Local time
- Today, 14:35
- Joined
- May 29, 2003
- Messages
- 169
Hello,
I want to set a date in the field [MyFieldStartDate], from which queries will be run. The start date cannot be on a Saturday or Sunday. (For the moment I am not concerned with national holidays.)
If someone could help, that would be great!
Here is psuedo code if what I want to do:
If strToday = (Saturday or Sunday) Then Set the date of [MyFieldStartDate] to (the date of Friday of last week)
However!
If strToday = Any other day of the week, then [MyFieldStartDate] is (yesterdays date)
Many thanks,
dj_T
I want to set a date in the field [MyFieldStartDate], from which queries will be run. The start date cannot be on a Saturday or Sunday. (For the moment I am not concerned with national holidays.)
If someone could help, that would be great!
Here is psuedo code if what I want to do:
If strToday = (Saturday or Sunday) Then Set the date of [MyFieldStartDate] to (the date of Friday of last week)
However!
If strToday = Any other day of the week, then [MyFieldStartDate] is (yesterdays date)
Many thanks,
dj_T