[AccessD] Date format problem

Darren DICK d.dick at uws.edu.au
Mon Jul 19 17:46:05 CDT 2004


Hi Chester
By adding "yy" to the end of the 'syntax' you are actually telling Access to only return
2 digits of the year 
If you want to see all four digits of the year, try adding "yyyy" to the end of your syntax instead of just "yy"
You can even add something like "dd/mm/yyyy" or "mm/dd/yyyy" to see the whole date expression

Hope this helps

Darren

----- Original Message ----- 
From: "Kaup, Chester A" <kaupca at chevrontexaco.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, July 20, 2004 1:22 AM
Subject: RE: [AccessD] Date format problem


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