Determining the day of the week

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

payroll weeks / varying first day and week of the year 2
Need Monday date for given week number 4
Filter for Day of the Week 4
Want the week number of a given date 5
Sum Query 1
report filter day of the week 2
week numbers 3
How do I get Monday to be the first day of the week? 1

Top