[AccessD] Date format problem

All I want is the last 2 digits of the year. It needs to be that way to
load into another program.

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 Darren DICK
Sent: Monday, July 19, 2010 5:47 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date format problem


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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com