NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Richard I on July 28, 2024, 01:32:12 AM

Title: FORMAT(SRIA:DOB,@D6)
Post by: Richard I on July 28, 2024, 01:32:12 AM

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

Title: Re: FORMAT(SRIA:DOB,@D6)
Post by: Johan de Klerk on July 28, 2024, 01:59:20 AM

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

Title: Re: FORMAT(SRIA:DOB,@D6)
Post by: osquiabro on July 28, 2024, 04:09:07 AM

@d06

Title: Re: FORMAT(SRIA:DOB,@D6)
Post by: Richard I on July 28, 2024, 09:50:46 PM

@D06B
Too Simple!

Many thanks
Richard