Conversion of Date to Number

[marystewart78]

Hi folks,

I'm sure this is pretty simple to do but I'm stuck - please help if you can!

I have a table with a date field and once the date is entered I would like it to automatically generate a reference number in the Ref No field which is the date as a number in reverse order ie 16th August 2005 would become 20050805 - how can I do this???

Many Thanks,

Mary

 

[john471]

In a query....

SELECT Format([YourDateField],"yyyymmdd") AS YourRefField
FROM tblYourTableName;

You wouldn't want to store the result of a calculated field in a table, would you, as that would be bad practice....

... ie 16th August 2005 would become 20050805 - how can I do this???

ie 16th August 2005 would become 20050816