[AccessD] Date format problem

Kaup, Chester A kaupca at chevrontexaco.com
Mon Jul 19 10:22:48 CDT 2004


Selected year contains the value 2004. It can contain any year value
from 2001 to 2010 depending on what the user selects from the list box.

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. 




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael
Brosdorf
Sent: Monday, July 19, 2004 9:37 AM
To: Access Developers discussion and problem solving
Subject: AW: [AccessD] Date format problem


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
-- 
_______________________________________________
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