Solved: Date Logic - Qlik Community

panipat1990 · ‎2016-11-21

Dear Sir,

I stuck a requirment. In my raw data my date format is 20.11.2016. in text format. how i convert in number format and proper date format.

My Date Format from sourceTo is=20.11.2016

i Want to this=20/11/2016

For this i am sharing a excel.

jonathandienst · ‎2016-11-21

=Date(Date#(sourceTo, 'dd.MM.yyyy'), 'dd/MM/yyyy')

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

jonathandienst · ‎2016-11-21

=Date(Date#(sourceTo, 'dd.MM.yyyy'), 'dd/MM/yyyy')

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

Anonymous · ‎2016-11-23