topic Re: Can I convert Text date to Date format?hi in QlikView

Can I convert Text date to Date format?hi

chandu441 — Wed, 15 Jul 2015 13:59:07 GMT

Please anyone give solution for my doubt?

I know how to convert date format to number or text in qlikview

In my QVD Date format is like Num. You can see the Number in Modified_Date Colum in below:-

Just I want to know how can I convert the Number in Date Format?

I have gone through several sites and articles but I didn't find my solution properly. So I'm raising my doubt here for getting my solution.

Thanking you In-Advance

alexandros17 — Wed, 15 Jul 2015 15:24:49 GMT

Date(Modified_Date, 'DD/MM/YYYY')

settu_periasamy — Wed, 15 Jul 2015 15:38:25 GMT

Just put date function.

Date(Modified_Date)

maxgro — Wed, 15 Jul 2015 15:41:51 GMT

for date start here (also read the pdf at the end)

date(yourfield)