[AccessD] Date format problem

Try "yyyy"

Perry Harold

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester A
Sent: Monday, July 19, 2004 9:45 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Date format problem


The following expression in a query returns 2004    Test:[Forms]![frm
Select Date]![selected_year]
The following expression returns 05 in a query Test:Format([Forms]![frm
Select Date]![selected_year],"yy")

I an confused as to what is happening here. Help please.



Chester Kaup
Information Management Technician
IT-MidContinent/MidContinent Business Unit
CTN 8-687-7415  
Outside 432-687-7414

No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced. 



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com