topic Re: Applying timestamp format to all date field in App Development

Applying timestamp format to all date field

Aryasmank — Tue, 13 Dec 2022 10:08:25 GMT

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 — Tue, 13 Dec 2022 10:31:03 GMT

One way is as follows

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

Aryasmank — Tue, 13 Dec 2022 11:39:13 GMT

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?