Good day
Could someone please assist?
When I extract a date from our Oracle Data Warehouse, it shows in Qlikview in a timestamp format.
Is there a way to counter this without a "workaround"?
//Script
select
CALENDAR_DATE,
LY_CALENDAR_DATE,
FIN_WEEK_END_DATE
from
DIM_CALENDAR;
All three fields have a timestamp format in Qlikview with 00:00:00 time. In the source table it had a DATA_TYPE of Date.
//Workaround
LOAD
FIN_WEEK_END_DATE,
date(CALENDAR_DATE) as CALENDAR_DATE,
date(LY_CALENDAR_DATE) as LY_CALENDAR_DATE;
select
CALENDAR_DATE,
LY_CALENDAR_DATE,
FIN_WEEK_END_DATE
from
DIM_CALENDAR;
In the workaround, CALENDAR_DATE and LY_CALENDAR_DATE now appear in date format in Qlikview. FIN_WEEK_END_DATE is in timestamp format.
Anybody know what I'm missing?