[AccessD] weekdays

Helmut and Gustav,

thanks for the help. It did the trick.

Pedro


----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Thursday, February 16, 2006 10:32 AM
Subject: Re: [AccessD] weekdays


> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>