Problem with dates

[francisvandergr]

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 ?

[MayilVahanan]

Hi

PFA

[#3]

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,

[francisvandergr]

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)