[AccessD] Date format problem

Kaup, Chester A kaupca at chevrontexaco.com
Mon Jul 19 08:45:05 CDT 2004


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. 






More information about the AccessD mailing list