[AccessD] weekdays

Gustav Brock Gustav at cactus.dk
Thu Feb 16 03:32:28 CST 2006


Hi Pedro

Oops, you wish the weekday to be spelled out?

  Format([date], "dddd", 2)

will give you the localized name of the weekday.

/gustav

>>> Gustav at cactus.dk 16-02-2006 10:13:26 >>>
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




More information about the AccessD mailing list