Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello
Same problem, Try this:
DATE(LEFT(FLOOR(NUM(purgechar(tempData,'[.]'))),5)) as date,
Luck!
Use this sentence on a sript:
Date(Num(Evaluate(tempData) )) as newDate