Date(sales)

[purna]

Hello qlikers,

can any one please explain what happen in the front end for D_d.

LOAD
"Date",
Sales,
Category,
Country,
Region,
Date(Sales) as D_d
FROM [lib://DataFiles/]

Please find the attachment, why it is giving 1900 year, is it comparing the year with present year, if it so i don't have the data for 1900 year.

regards....

[abhijitnalekar]

Hi @purna,

With this syntax, Qlik is not able to identify the format for the date so by default it is showing 1900 

Date(Sales) is not proper syntax. please change the same with Date(Sale,'DD-MMM-YYYY') this will give you the proper result.

I am assuming that sale is a date field in the data. 

[purna]

Thanks for the reply abhijit...

But throwing the same with different dilimiter..

[abhijitnalekar]

H @purna,

Please modify the same with below expression

date(Date#(sales,'MM/DD/YYYY'),'DD-MMM-YYYY') as D_d