UPDATE DATE as update field display in Qlik Sense as 42515 ?

[paulyeo11]

Hi All

Below is the load script , that read from Excel file .

LOAD

  CUST_ID  as [CUST_ID],

    [UPDATE DATE] AS [update],

    STATUS       as [status],

  PAYMENT_DATE as [PAYMENT_DATE]

FROM [$(vINPUTPath)$(vFile18)] (ooxml,embedded labels, table is [TID]);

I use Binary load to read the above QVW file. When in Qlik View i can create table report to display both date no issue.

But when i use Qlik Sense to read the above 2 date , i am not able to read the date , it turn the date into number 42515.

Hope some one can advise me what are the changes i need make , in order for Qlik Sense able to display date as 23/6/2016 ?

Paul

[arulsettu · Accepted solution]

try like this

LOAD

  CUST_ID  as [CUST_ID],

   date( [UPDATE DATE]) AS [update],

    STATUS       as [status],

  date(PAYMENT_DATE) as [PAYMENT_DATE]

[paulyeo11]

My QS QVF

Take note that the field name = UPDATE , is display as number not date format.

I also notice in QS Table , i am not able set the field as date . it does not allow us to set.

PAul

[arulsettu]

[Chanty4u]

hi,

PFA

[paulyeo11]

Hi Arul

Thank you very much , it work

Paul

[paulyeo11]

Hi Chanty

Arul approach work fine .

When i open your attach file , i still see number and not see the date.

After i try Arul by add Date( it work fine.

Paul

[arulsettu]

welcome