Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
Can you please let me know how to read this kind of date format in QlikView. I have used different date formats but nothing worked.
Read the date as is and display in QlikView.
BTW, these date are coming out of Teradata.
I have connected Teradata and QlikView using ODBC and reading the date columns.
Hi @manideep78 , please try creating a new field like this :
LOd
fields..
DateField,
date#(substring(DateField, ' ', 1)) as DateField2
From yoursource;
Is going to separate the date using space as separator for the subfield function.
Just take care of the date separator '/', can be replaced for '-' if needed, but with Date# function should be work