Date data type from excel file usinn max function

[#1]

Hi

i load date from excel file table.

when i use a MAX function on the Date column it return a number

only when i use Maxstring function it return the max Date .

why?

the column is define as a date in the excel file why i can not use MAX function ?

[Anonymous]

Hi sharon,

                 U nid to chk d excel format for d concerned field.

Regards,

Vaibhav

[#3]

Sorry

didn't uderstand your answer

[martinpohl]

like in excel, too, QV stores a date or a timestamp as a number.

For that you can calculate them for example.

by using date(max(datefield,'MM/DD/YYYY') you will get the date shown as a date.

Regards

[giakoum · Accepted solution]

QlikView does not identify that field to be a date. You need to expalin that to QlikView.

If you date format is 19.09.2012 for example, you need to set that command prior from loading :

SET DateFormat='DD.MM.YYYY';

[#6]

Help a lot

it is working good

Thank you .

[giakoum]

Please close this disucssion by marking it as correctly answered.

Thank you.