AW: [AccessD] Date format problem

Michael Brosdorf michael.broesdorf at web.de
Mon Jul 19 09:36:59 CDT 2004


What exactly does the field 'selected_year' contain? 

Michael

-----Ursprungliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Kaup,
Chester A
Gesendet: Montag, 19. Juli 2004 15:45
An: accessd at databaseadvisors.com
Betreff: [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



More information about the AccessD mailing list