Been searching but can't find an answer to my particular problem. Have imported a large number of dates with the formats of "01-12-2014" and "1-12-2014". I'm after a Auto Enter Calculation that will automatically add the "0" to the day, such as "01-12-2014" and not "1-12-2014"

 

With Thanks

Hi, since that format is dependent upon the OS settings, it doesn't really make sense to control it at the data level.  Have you tried selecting the field, and in Inspector, go to Data tab and at the bottom under Data Formatting, set the date (calendar display)  to the CUSTOM format you wish, probably the second one and then below select display leading zeros on month.  :-)

Assuming those are valid dates, residing in a date field, you can simply format the field to display them with leading zeros and not worry about the way the data was actually entered.

 

BTW, auto-enter calculations work during data-entry, not after. So it won't help you if your data is already imported.

Thanks for the quick reply, the moment I started to read your reply I realised what an idiot I was, sorry to bother you with such a question. I'm still kicking myself.

 

Thanks Again.