Connecting Tech Pros Worldwide Help | Site Map

Date in date code format

  #1  
Old November 13th, 2005, 11:04 AM
Bob Sanderson
Guest
 
Posts: n/a
Does Access have a function to convert a date into a date code (i.e.
today's date would be displayed at 051805).
  #2  
Old November 13th, 2005, 11:04 AM
Tim Marshall
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date in custom format phpmagesh answers 4 October 6th, 2009 01:56 PM
Problem in date fields creative1 answers 7 November 8th, 2007 07:09 AM
Acess Date Code (Julian Date) IsdWeb answers 4 February 6th, 2007 10:15 PM
need help in date code..find all product that expired in the month tomerslider@nana.co.il answers 1 November 13th, 2005 04:05 PM