DATE FORMATTING

E

Eric

Is it possible to format a date to the folowing format: dd-mmm-yyyy

for example: 19-OCT-2006

Thanks.
 
S

Steve C, MFS

Yes! On the property sheet for the control (whether a form or report) there
is an entry for format. This has a drop down list of common formats, or you
can type your own using the standard notation. You don't need to add quotes
so just put your dd-mmm-yyyy in the format box.
 
Top