Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 :
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 :