Load dates from Excel

[chriys1337]

Hi,

I am loading some dates from an Excel, which are formatted as date in Excel and represented like "01.05.2017".

When I load my crosstable in QlikView the date field displays numbers, e.g. 42877 - that's fine till then, BUT they are recognized as a text, they are stated on the left side of the field in the frontend.

And formatting in the script with date(date#(Date_Field,'DD.MM.YYYY'),'DD.MM.YYYY') as Dates_New

does not help anything, these numbers are still shown on the leftside, instead of the right.

Can anybody help please?

Chris

[Digvijay_Singh]

Maybe try this, looks like they are date numbers while importing -

date(num(Date_Field),'DD.MM.YYYY') as Dates_New

[Anil_Babu_Samineni]

Are you doing this in Cross Table? Can you confirm this, If so, Please mention how script looks like

Please have  a look Re: Crosstable numeric values

[prma7799]

Please share some sample data.

[qlikview979]

Hi,

please share the sample file.