Does Access have a function to convert a date into a date code (i.e.
today's date would be displayed at 051805).

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