topic Issue in comparing date format in QlikView

Issue in comparing date format

Thu, 04 Jun 2015 09:29:33 GMT

Hi All,

I have used the below expression for comparing the date format of a field.

isnum(date(date#(datefield,'MM-DD-YYYY'))).

When I load the datefield, then eventhough the values present in the field are in the format MM-DD-YYYY, but still it is returning 0.

I have to basically compare some field values against dofferent date formats and assign the values as described below:

1.If datefield has values in DD-MM-YYYY, then the field Date value should contain DD-MM-YYYY

2. If datefield has values in MM-DD-YYYY, then the field Date value should contain MM-DD-YYYY

3. If datefield has values in MM-DD-YYYY hh:mm:ss TT, then the field Date value should contain MM-DD-YYYY hh:mm:ss TT

4. 3. If datefield has values in hh:mm:ss, then the field Date value should contain hh:mm:ss

Can someone help in this?

Thanks,

Asma

arulsettu — Thu, 04 Jun 2015 09:31:29 GMT

post your sample file

swuehl — Thu, 04 Jun 2015 09:34:51 GMT

Look into the alt() function, this should make it easy to parse different date and time formats in.

Coming to your issue with a date field not being parsed correctly, could you post at least some samples of your date field?

madhumitha — Thu, 04 Jun 2015 10:25:23 GMT

Hello Azma,

Please try this

isnum(date#(text(datefield),'MM-DD-YYYY'))