Problem to load Date from Excel!

[#1]

Hi,

The date on excel is a numeric value.

40452 is 2010-10-01 (YYYY-MM-DD)

While loading the 40452 from the Excel file, how can I load it as a date type value?

Best Regards,

Cassiano

[#2]

Hello

Same problem, Try this:

DATE(LEFT(FLOOR(NUM(purgechar(tempData,'[.]'))),5)) as date,

Luck!

[#3]

Use this sentence on a sript:

Date(Num(Evaluate(tempData) )) as newDate

[sasiparupudi1]

Rename Column Names Programatically in the Qlikview Script