Date Formats

[dazzjazz]

I need to pull a date field out of FM5 in the format dd/mm/yyyy - which is the format it's stored in thge database.

however, any leading zeros are being stripped ie 02/02/2003 become 2/2/2003.

Is there any way to force the correct format ?

Dazzjazz

[JenMorley]

You could make a calculation to put the date into text with the zeros you want and then take the date out of the calculation instead.

I saw you can put extra zeros on with the Right function.

[Redfern]

You can export with formats from a layout, so if you are exporting, maybe just set the field with a custom date format with leading zeros for day and month and export with formats.