Format Dates WITHOUT '/' seperators ?

[liamfitz]

I'm trying to formt a Date data type as follows

Format(dt, ddmyy)

This however returns, for example if dt = Today - 25/06/2012

I'd like to return just the numbers, without the '/' seperators, and two digits for year i.e (250612) ? Thanks if you can help.

 

[bob fitz]

try:
Format(dt, "ddmmyy")

 

[liamfitz]

Will do. thanks.