Can I convert Text date to Date format?hi

[chandu441]

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

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

[settu_periasamy]

Just put date function.

Date(Modified_Date)

[maxgro]

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

Get the Dates Right

date(yourfield)