Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

Date Logic

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Date Logic

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

2 Replies
MVP
MVP

Re: Date Logic

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

Community Browser