Date Logic

[panipat1990]

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 · Accepted solution]

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

[Anonymous]

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/d...