convert GMT format to date format

[Anonymous]

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

[brunobertels · Accepted solution]

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 :