FORMAT(SRIA:DOB,@D6)

[Richard I]

When exporting records to a CSV file, using the  code, ExpCSV:Label11 = FORMAT(SRIA:DOB,@D6)
places the date as dd/mm/yyyy  when   the date is >= 10/mm/yyyy, to the right of the cell
Those dates < 10/mm/yyyy are to the left of the cell

Is there are date picture that places a leading zero in the dd/mm/yyyy  such as 09/mm/yyyy when the day date is <10
I have tried RIGHT(Format..... which extenuates and its less than elegant

Thanks
Richard

[Johan de Klerk]

Hi Richard,

Don't know if it will help.
Take a look at Carl's "Date-Time-Number-Tool".
https://github.com/CarlTBarnes/Date-Time-Number-Tool

Regards
Johan de Klerk

[osquiabro]

@d06

[Richard I]

@D06B
Too Simple!

Many thanks
Richard