Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Excel Date Format

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

Tags (3)
2 Replies
Not applicable

Excel Date Format

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

Not applicable

Excel Date Format

Hi,

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

Cheers.

Community Browser