[OT] Convert date in Access

Yahoo Archive
1
Sarah -

Tonumber(date_field).

HTH,
Calvin

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, November 25, 2003 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] Convert date in Access


Doe anybody know in MS access, how to convert a DATE to the corresponding
6-digit number field representing that date?


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Doe anybody know in MS access, how to convert a DATE to the corresponding
6-digit number field representing that date?
3
I think you can get there by using something like this in VB

datepart("D", date) will return the day value
datepart("M", date) will return the month value
datepart("yy", date) I think will return the year value

and then combine them in the order you want, its not pretty but I think it
will work.

Mark Dupuis


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, November 25, 2003 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT] Convert date in Access


Doe anybody know in MS access, how to convert a DATE to the corresponding
6-digit number field representing that date?

Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]