Date Manupulation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field on my Form which will show the next days date like this

If Today is Monday(Jan 01,2004), then my field wil show tommorrow's date(Jan 02, 2004

and if Today is Friday(Jan 05, 2004) then my field will show Monday's date (Jan 08, 2004

Can anyone help?? thanks....
 
Is this a query question?

Select DateAdd("d",IIF (WeekDay(DateField)
=6,3,IIF(Weekday(DateField)=7,2,1),DateField) as Tomorrow
....

Or

Select DateAdd("d",Choose(Weekday(DateField),1,1,1,1,1,3,2),DateField)
....
 
Back
Top