Applying timestamp format to all date field

[Aryasmank]

Hi All,

while loading the data from the SharePoint list , the date fields are in the  ' 2022-11-17T18:50:00Z ' format.

there are  12 date fields in the list. Is there any way to convert them all at one to "DD-MM-YYYY  hh:mm:ss" format.

I have tried to provide timestamp format at main  in the load script but it's not working. 

Please suggest any solution to that.

Thanks,

Mayank

[BrunPierre]

One way is as follows

Timestamp(Timestamp#(DateField,'DD-MM-YYYYThh:mm:ssZ'),'DD-MM-YYYY hh:mm:ss')

[Aryasmank]

Hi @BrunPierre ,

Thanks for your suggestion, from the above expression, I have to do this for every Datefield.

My requirement is that, is there any way to convert these all DateFields in a single expression?