convert GMT format to date format

Anonymous — Mon, 23 May 2022 19:53:43 GMT

Dear community,

I want to convert a field in this format 'Fri Apr 02 00:00:00 GMT 2021' to a date format, like this '02.04.2021'

Thanks for any help

Felipe

Re: convert GMT format to date format

brunobertels — Tue, 24 May 2022 09:41:01 GMT

Hello

Try this

date(
makedate(right('Fri Apr 02 00:00:00 GMT 2021',4), // to get year

num(month(date#(
subfield('Fri Apr 02 00:00:00 GMT 2021',' ',2),
'MMM'))), // To get Month

subfield('Fri Apr 02 00:00:00 GMT 2021',' ',3) // to get Day
),'DD/MM/YYYY')

replace 'Fri Apr 02 00:00:00 GMT 2021' by your actual date dimension

Result :