Error: DATE format

[Purushothaman]

Hi there,

Attached is my dataset and QVF.  

I am unable to convert into the DOB to Date Field. 

Anyone, Please help!!

Thank you.

[SankarReddyK · Accepted solution]

Hi @Purushothaman , please use the resident load to solve your problem.

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/load-data-from...

Raw:
LOAD
Date(DOB) as Date
FROM [lib://file (qtsel_sut)/DOB.xlsx]
(ooxml, embedded labels, table is Date);

Raw1:
Load
Date(Date#(Date,'M/D/YYYY'),'DD.MM.YYYY') as Date1
Resident Raw;

Thanks,

Sankar.

[Lisa_P · Accepted solution]

I think it is working fine without trying to transform it.

If you make your default Date format as D/M/YYYY it changes it in a chart as a dimension..

[Purushothaman]

HI @SankarReddyK ,

Thank you,  Its working. However. The Data format is still $Nummeric $Integer. Not showing $Date,

Thank you!

[SankarReddyK]

Hi @Purushothaman , Please refer the below article for more details.

https://community.qlik.com/t5/Member-Articles/Dealing-with-date-formats-in-QlikView-and-QlikSense/ta...

Best Regards,

Sankar.