[AccessD] Date format problem

Arthur Fuller artful at rogers.com
Wed Jul 21 11:53:24 CDT 2004


Why not modulus the year with 100 and grab the modulo? 

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
A
Sent: Tuesday, July 20, 2004 8:07 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Date format problem


That would work but I only want 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 Perry Harold
Sent: Monday, July 19, 2004 5:29 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Date format problem


Try "yyyy"

Perry Harold

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
A
Sent: Monday, July 19, 2004 9:45 AM
To: accessd at databaseadvisors.com
Subject: [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