Timestamp french format

[jmialoundama]

Hi , 

I have this format timestamp :  

I want this timestamp format : 01/01/2018 12:00:00 instead of 1/1/2018 12:00:00 AM

[Taoufiq_Zarra]

Maye be :

=Timestamp(Timestamp#('1/1/2020 12:00:00 PM','DD/MM/YYYY h:mm:ss TT'))

[jmialoundama]

Hi Tariq, 

I try tour solution but it's doesn't work. 

[Taoufiq_Zarra]

can you share a sample data

[rwunderlich · Accepted solution]

On your Main script tab, change your TimeStamp format to:

SET TimestampFormat='DD/MM/YYYY hh:mm:ss';

-Rob