Day of week.

E

Engineer Captain

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?
 
D

Duane Hookom

"corresponding day of the week" could be displayed as
2
Monday
Mon
Check the Format() function or Format property in Help.
 
O

Ofer

WeekDay(FieldName) will return the day number = 4

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