Day of week.

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

Guest

I have a data base tracking Improvised Explosive Device Detonations for my
Brigade Combat Team. I enter the dates as dd-mmm-yy. How can I have these
displayed as the corresponding day of the week?
 
"corresponding day of the week" could be displayed as
2
Monday
Mon
Check the Format() function or Format property in Help.
 
WeekDay(FieldName) will return the day number = 4

Format(FieldName,"dddd") will return the day string = Wednsday
 
Back
Top