Connecting Tech Pros Worldwide Forums | Help | Site Map

Date in date code format

Bob Sanderson
Guest
 
Posts: n/a
#1: Nov 13 '05
Does Access have a function to convert a date into a date code (i.e.
today's date would be displayed at 051805).

Tim Marshall
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Date in date code format


Bob Sanderson wrote:
[color=blue]
> Does Access have a function to convert a date into a date code (i.e.
> today's date would be displayed at 051805).[/color]

format(date(),"mmddyy")

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Closed Thread