How to change logindate type from varchar2 to Date type in qlik load editor script not in oracleDB

[satyaban]

Dear All,

I have a field called LOGINDATE with varchar2 type in Database and used for visualization in qlik sense .

In order to used date picker extension in qlik sense LOGINDATE should be in DATE datatype while it is varchar2 in DB.

Note : LOGINDATE cannot be DATE data type in DB due to some technical constraints and requirements .

Kindly suggest how to change that LOGINDATE field to DATE datatype in load script editor to  make it available for Data picker extension .

Thanks in advance .

[marcus_sommer · Accepted solution]

If it's a date you could use:

date(date#(LOGINDATE, 'FormatPattern'))

by a timestamp you need additionally to remove the time-part, like:

date(floor(timestamp#(LOGINDATE, 'FormatPattern')))

- Marcus