Solved: Date With Special Character - Qlik Community

R__M · ‎2019-12-19

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 · ‎2019-12-20

= 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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

jonathandienst · ‎2019-12-20

= 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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Date With Special Character