DATE FORMATTING

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

for example: 19-OCT-2006

Thanks.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
Combo box date format changes when item selected from list 4
Medium Date format and calendar in Access 2007 1
Need help with access expression - HELP!! 0
Form Control Calendar date will not change its format 1
Change System date format 1
Text Box Date Format 2
Combo box date format 3

Back
Top