loading date from excel

[#1]

Hi Experts,

       i have a date field like this(12-Nov-14)from excel. when i am loading this filed in to qlikview.

       it is strange sometimes it is loading the Month in upper case like (12-NOV-14) and some times it is in (12-Nov-14)
.. can any one let me know why it is behaving like that

[PrashantSangle]

Hi,

It is loading as text.

If possible share your excel file.

Regards

[Anonymous]

Using

Date(ExcelField,'DD-MMM-YYYY') should convert and format the data for you

[engishfaque]

Dear Sruti,

Use this one,

date(Num#(YourDateFieldName),'DD-MMM-YY')

or

date(Num(YourDateFieldName),'DD-MMM-YY')

Kind regards,

Ishfaque Ahmed

[sunny_talwar]

I would check if the date is actually being picked as a date by QlikView by creating a list box object with the expression =IsText(Date). If you see only -1, that means your date column is actually loaded in as text. If you see both 0's and 1's then some may be loaded as date/num and others as text (wherever it is -1). If it is all showing 0's then I would go into document properties and number tab and pick the date field and assign my own format which would then be consistent across the application.

Best,

S

[#6]

Hi Guys,

   It is not about conversion. actually the files are saved with .csv extension..when loading the date field from the

file the the text in the date filed is coming in upper case for some files and lower case for some of the files

[Anonymous]

Hi,

Try  Formatting date:

Date(Date,'DD-MMM-YYYY') as Date; - will display in text

or

Date(Date,'DD-MM-YYYY')  as Date; will display in numbers.

Reason for loading the Month in mixed case,because date field in excel file itself has mixed case month in date.

Regards

Neetha