Qlikview Date

[#1]

Hey guys, how is it going?

I have a data that comes from a excel spreadsheet, actually, it comes from a report manager where I download a report and then it is read by Qlikview.  The point is: To QlikView to read the field data, present in this report, I have to open the excel, sum 0 (+0) the date column present and then reload (I already tried make: Date(Datefield) as Datefield on qlik, but it didn't work).

Is there a solution?

Sincerely, Bisco

[HirisH_V7]

Hi ,

Can you provide sample data and issue facing with it!

-Hirish

[sunny_talwar · Accepted solution]

Have you tried using Date#() function? What format does it come in? May be look into these blogs by HIC

Why don’t my dates work?

Get the Dates Right