A query to display date backwards and without slashes

[KenshiroUK]

Pretty self explanatory, but I would like to create a query that displays a date like this "20130315"

Can this be done?

 

[pr2-eugin]

Did you try..

? Format(Date, "yyyymmdd")
20130315

 

[KenshiroUK]

Did you try..

? Format(Date, "yyyymmdd")
20130315

No, currently I just have Date() However there is a field within my table called "Date Done"

Nevermind I've figured it out. Thanks anyway.

 

[pr2-eugin]

just replace Date() with the field you wish to change change the format for..

 

[Brianwarnock]

No, currently I just have Date() However there is a field within my table called "Date Done"

Nevermind I've figured it out. Thanks anyway.

Wouldn't it be polite to say what you did.

Brian