Date Formats

F

Farmboy

We need date formats such as: YYYYMMDD and DDMMMYYYY, but cannot find in
default object library or how to add. Is there a way to get these date
formats [without hyphens or slashes]?

Thanks in advance.
 
P

Perplexed Access Designer

Go into the date picker properties and choose formats. The yyyymmdd is the
third from the bottom. However if this does not meet your needs,
1) in your data source, format the data to accept anything.
2) Use the data field properties Display to tell the user to format the data
in a certain way
3) Use Data Validation menu to only accept data if the data matches the
desired pattern.
 

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

Top