Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Please try to attach the sample excel for a solution or try something like Stephen suggested.
Cheers.