Date is not recognizing.

[Anonymous]

[tresB · Accepted solution]

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]

May be use Trim

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

[Anonymous]

Tried but didn't worked

[tresB]

Could you share the excel to check?

[Anonymous]

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

[sasiparupudi1]

Please close this thread

[Anonymous]

How?

[sasiparupudi1]

Qlik Community Tip: Marking Replies as Correct or Helpful