[AccessD] weekdays

Hi Pedro

There is no native SQL for that but for ISO weekdays use 

  Weekday([date], 2)

/gustav

>>> pedro at plex.nl 16-02-2006 09:33:37 >>>
Hello Group,

i now that there is an sql that can give me the days of the week fo a specific date, but i can't find it right now.

Who can help me?

i have:
date
16-02-06
17-02-06

i need:
date             day
16-02-06        thursday
17-02-06        friday

Pedro Janssen