Number format needs to be converted to date format

building reports webintelligence
1

Hi,

I have an object called date_id with datatype number. And it is showing values as 20100101 (YYYYMMDD). Can I have any function which can be create at report level to convert the same in to date format?

Plz. help

Thanks
Praveen

kk@bi (BOB member since 2009-06-16)

2

Hi,

Try a formula like this:

=ToDate(FormatNumber([date ID];"0");"yyyyMMdd")

Marek Chladny :slovakia: (BOB member since 2003-11-27)