topic Date With Special Character in Water Cooler

Date With Special Character

R__M — Fri, 07 Feb 2020 21:54:04 GMT

Hello Community,

I have a Date Field Contain data as "Monday,9Dec@2019".

Now i want Generate date as 09/12/2019 format. Please help me with this.

Thank you in advance

jonathandienst — Fri, 20 Dec 2019 05:43:20 GMT

= Date(Date#(SubField('Monday,9Dec@2019', ',', 2), 'DMMM@YYYY'), 'DD/MM/YYYY')

Subfield discards the day value / Date# interprets the date / Date formats it.

Replace the literal date with the field name.