Date Format without the "/"

E

erick-flores

Hello all

How do I format my date so the user can enter the date without the
"/". Example:

Right now (enter by user): 02/27/07 Final Result: 2/27/2007
I want (enter by user): 022707 Final Result: 2/27/2007



Thanks
 
A

Anthos

For those that would like to know the answer.
Set the field to a string.

Then run the format function over the top

Format("[fieldname]", "dd/mm/yyyy")

This will format what ever is in fieldname into the format dd/mm/yyyy
 
T

Thomas

Anthos said:
For those that would like to know the answer.
Set the field to a string.

Then run the format function over the top

Format("[fieldname]", "dd/mm/yyyy")

This will format what ever is in fieldname into the format dd/mm/yyyy
Click to expand...
 
Top