topic Date is not recognizing. in QlikView

Date is not recognizing.

Anonymous — Tue, 17 Apr 2018 06:54:29 GMT

tresB — Tue, 17 Apr 2018 07:01:29 GMT

Few of your dates are already in number. For them you just have to format it using date(). Hence try like:

Date(Alt(Date, Date#(..), Date#(...)), 'DD/MM/YYY') as Date1

sasiparupudi1 — Tue, 17 Apr 2018 07:14:42 GMT

May be use Trim

Date(Alt(Date#(Trim(Date),'DD/MM/YYY'),Date#(Trim(Date),'D/MM/YYY'),) 'DD/MM/YYY') as Date1

Anonymous — Tue, 17 Apr 2018 09:10:28 GMT

Tried but didn't worked

tresB — Tue, 17 Apr 2018 09:14:15 GMT

Could you share the excel to check?

Anonymous — Tue, 17 Apr 2018 10:36:55 GMT

I changed system date and now it's working fine. Thank you guys.

sasiparupudi1 — Tue, 17 Apr 2018 10:40:19 GMT

Please close this thread

Anonymous — Wed, 18 Apr 2018 07:20:58 GMT

How?

sasiparupudi1 — Wed, 18 Apr 2018 18:39:31 GMT