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