[AccessD] weekdays

Helmut Kotsch hkotsch at arcor.de
Thu Feb 16 03:28:45 CST 2006


In the German version of Access it is Format([yourdate];"tttt") for the full
day name and Format([yourdate];"ttt") for a 2-letter day name. In the
English version of Access I think tttt should be replaced with dddd.

Helmut

-----Ursprungliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von
pedro at plex.nl
Gesendet: Donnerstag, 16. Februar 2006 09:34
An: accessd at databaseadvisors.com
Betreff: [AccessD] weekdays


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




More information about the AccessD mailing list