NetTalk Central

Author Topic: FORMAT(SRIA:DOB,@D6)  (Read 2892 times)

Richard I

  • Sr. Member
  • ****
  • Posts: 398
    • View Profile
    • Email
FORMAT(SRIA:DOB,@D6)
« 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
« Last Edit: July 28, 2024, 01:45:50 AM by Richard I »

Johan de Klerk

  • Full Member
  • ***
  • Posts: 217
  • Johan de Klerk
    • View Profile
    • Designer Software
Re: FORMAT(SRIA:DOB,@D6)
« Reply #1 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
Clarion 10, NT 11.57

osquiabro

  • Hero Member
  • *****
  • Posts: 687
    • View Profile
    • Email
Re: FORMAT(SRIA:DOB,@D6)
« Reply #2 on: July 28, 2024, 04:09:07 AM »
@d06

Richard I

  • Sr. Member
  • ****
  • Posts: 398
    • View Profile
    • Email
Re: FORMAT(SRIA:DOB,@D6)
« Reply #3 on: July 28, 2024, 09:50:46 PM »
@D06B
Too Simple!

Many thanks
Richard