Format Conversion

[NeonSky via AccessMonster.com]

Good Day,

How is everyone today?

Quick question, how do I run an update to convert date values to the
following format: from "5/11/2008" to "11-May-08" ?

Thank you!

 

[Michel Walsh]

Format( yourDate, "dd-mmm-yyyy")


or


Format( yourDate, "dd-mmmm-yyyy")




as in:

? Format(now, "dd-mmm-yyyy")
05-Sep-2007

? Format(now, "dd-mmmm-yyyy")
05-September-2007



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

You do not UPDATE if it is a date field.

You just format the display output.