Date Format without the "/"

[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

 

[erick-flores]

I got it

 

[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

 

[Guest]

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