Convert date, not how it displays

[jodiefrench]

My date field needs to have the data in the exact format of mm/dd/yyyy.  I'm not talking about how it displays, I need the month and day to always have a preceding zero, if either of them is <10.

 

If my current date field includes the date 1/12/14, I need it converted to 01/12/2014.  

 

Is there a formula that will convert the actual data to this?  I've tried several things, but am not finding what I need.

 

Thanks.

[Kris M]

http://www.briandunning.com/cf/893

 

date.format ( thedate ; "mm/dd/yyyy" )

[comment]

If my current date field includes the date 1/12/14, I need it converted to 01/12/2014. 

 

Why do you (think that you) need this?

 

 

If you really do (and I am quite confident that you don't) need this, you could:

 

1. Show all records;

2. Replace the date field's contents with a calculated result =

 

SerialIncrement ("00" ; Month ( YourDateField ) ) & SerialIncrement ("/00" ; Day ( YourDateField ) )  & SerialIncrement ("/0000" ; Year ( YourDateField ) )

to convert existing records, and set the field to auto-enter a calculated result - using a similar formula - to correct future entries.

 

---

   Make sure you have a backup before trying step #2 above.