Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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
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