Excel Date Format

[#1]

Hi everyone!! I am a recently new QlikView Developer and I have a problem with Excel import data with date format.

The cells that need to put in QlikView as a Date Format are with DateFormat in Excel, but after the load script the field always keep in number format, so I tried to format with the Date Functions but I can't do it well, and if give format number Date in Documents Properties either show me as number...

Somebody can help me please!! The load script from excel it's  crosstable function...

Thanks everybody!!!

Milton

[#2]

I have had the same problem and had to do something like:

Date(Date#(YourField),'MM/DD/YYYY').'MM/DD/YYYY') as NewFieldName.

hth,

Stephen

[#3]

Hi,

Please try to attach the sample excel for a solution or try something like Stephen suggested.

Cheers.