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