Determining the day of the week

[Michel Khennafi]

Good morning...

We have a date field in a table of our database "10/12/2007" for instance
(mm/dd/yyyy).

I would like to determine what day of the week this date is
(0=Sunday,1=Monday,...)

What would be the function I need to use? I tried the WEEKDAY function but
does not give me the expected result.

Any help would be greatly appreciated.

Thanks so much

MK

 

[Ofer Cohen]

Try

Format([DateField],"dddd")

To return the name of the day

 

[Klatuu]

Read VBA Help on the WeekDayName function