Can't read dates when using Excel as a data provider

building reports webintelligence
1

I want to use an excel sheet as a data provider, however my dates gets scrambled.
If I read the dates as “Dates” then a get a null object.
If I read those dates as number then I get the date number equivalent ( I believe Excel is using the number of days since 1900 to the date you are representing).

Is there any way to read dates from an excel sheet. If not is there a function to convert the excel “date number” into a real date in WEBI?

Thanks.

Update:
It appears I might have found an answer.

Say i have a date in my excel sheet for 2/29/2008.
The number excel will suply to WEBI is 39476

By using the function below I can get back into the date
=RelativeDate(‘12/31/1899’;39476)

Please tell me if this is the most elegant solution or if there is a better one?

Thanks again.

tomhatz (BOB member since 2011-09-11)