#FORMAT - Date error in webi

building reports webintelligence
1

Hello

I need some help on this please

I was trying to get the year from dateformat. I have created a dimension object named YEAR. I have a date object in this format(Eg: 17/11/2009). The formula I used for YEAR object is:

=Year([Date])

which throws an error : #FORMAT, when I tried to pull the object into the table.

Any help Guys

Thanks in advance

ravi.bo :uk: (BOB member since 2009-09-01)

2

I presume its a report level variable you have created?

Have you tried formatting it as a number?

Mak 1 :uk: (BOB member since 2005-01-06)

3

Hi,

it seems your date datatype is not correct.
you can try converting data type using todate(), FormatNumber() etc…

I hope it will help.

Regards,
Vishvanath

vishvanath :india: (BOB member since 2009-10-26)

4

ohh, thanks mate. Missed simple thing. Tough day…

Thanks for your help, changing number format worked and yes it is a report level VAR.

Regards

ravi.bo :uk: (BOB member since 2009-09-01)