weekend calculation

[Guest]

My order system currently counts data after 2:00 PM as next day. When adding
up how many orders per day we received, I added an IIf statement that states

IIf(TimeValue([Date/Time])>#2:00:00
PM#,DateAdd("d",1,DateValue([Date/Time])),DateValue([Date/Time]))

The only problem is that for Fridays, it adds one day which of course makes
it counted for Saturday, but it should be counted for Monday. How do I go
about making Access realize if it is a Friday - DateAdd "d" 3, instead of 1
days?

 

[Wayne Morgan]

Nest IIf statements. Check to see if today if Friday, if so, add 3 instead
of 1.

IIf(TimeValue([Date/Time])>#2:00:00 PM#,
IIf(Weekday([Date/Time]) = 6, DateAdd("d",3,DateValue([Date/Time])),
DateValue([Date/Time])))