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