Date Format 1

[gregmw]

I have a field in Access which is formated as Date/Time I would like to make a field from this that is formated Just date "dd/mm/yyyy" is there an easy fomula in access for this?

Thanks very much

 

[mwolf00]

Try this...

SELECT formatDateTime(myField,2) FROM myTable Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

 

[gregmw]

I am using Access 97 and it dosen't regonise the function formatDateTime

 

[mwolf00]

MIght be a better way, but this works...

SELECT dateSerial(year(entered_on), month(entered_on), day(entered_on))
FROM jobs; Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com

 

[gregmw]

Thanks very much