topic Re: Problem with dates in QlikView

Problem with dates

francisvandergr — Tue, 22 Jan 2013 22:01:30 GMT

I have a txt file with a text field "Last Backup to appliance2". I tried to convert this field to a date field. But this doesn't work. I attached to files the qvw and the datasource file.

Can someone help me ?

Re: Problem with dates

MayilVahanan — Tue, 22 Jan 2013 22:26:10 GMT

PFA

Re: Problem with dates

Tue, 22 Jan 2013 22:51:25 GMT

You have to convert that text field to date using the correct format:

Date#([Last Backup To Appliance], 'MM/DD/YYYY h:mm TT') AS TheDate

Attached I am sending your file using the same method as you (with IF in the calculated dimension), and with a better approach using set analysis: Sum({<TheDate={"<21-01-2013"}>} 1)

Regards,

Re: Problem with dates

francisvandergr — Mon, 28 Jan 2013 13:14:54 GMT

Thank you. Can this also work with times? So i wanna see all records before a time :

for example all records before : 22-01-2013 6:02 AM

i have tried understanding formula.

Sum

({<TheDate={"<22-01-2013 6:02 AM"}>} 1)