Bilbo_Baggins_Esq
Registered User.
- Local time
- Today, 16:38
- Joined
- Jul 5, 2007
- Messages
- 586
Bob,
It is giving previous business day which is Friday 16 and will give 16th on Sunday and Monday.
This is what it is showing 16/01/2009
But I just realised that I had Date() for Tuesday to Friday and should be Date()-1
IIf(Weekday(Date())=2,Date()-3,IIf(Weekday(Date())=1,Date()-2,IIf(Weekday(Date())=7,Date()-1,IIf(Weekday(Date())>2 And Weekday(Date())<7,Date()-1))))
Mike375,
While this may work, isn't it more desirable to limit the IIF tests if possible?
IIF tests are slower and should be avoided/limited if it is possible???