Date Format

[#1]

Hi,

I have a set of data exported from a Excel file in the box. This file automatically have the data from Aggregate using QlikView. The problem is when I use the Qliksense desktop all dates fields not recognized as a date.

my format date in Qliq view :

SET DateFormat='DD-MMM-YYYY';

SET TimestampFormat='DD-MMM-YYYY hh:mm:ss[.fff]';

Thanks

[sunny_talwar]

What is the date format in the Excel files? May be check these links out

QlikView Date fields

Get the Dates Right

Why don’t my dates work?

[Anil_Babu_Samineni]

Can you share few date lists ??