Skip to Content
0
Former Member
Jun 12, 2009 at 05:08 AM

Webi rich clinet - problem in date

31 Views

Experts,

I m working in webi rich client evaluation version. I have one problem while creating report. The data is from BEx query and the field are from the Cube which is not having the date formate. The problem is,

If i have data which is date formate like month/year, example 02/2008. If i want to create the quarter from this date formate(month/year) using formula, the webi showing formula error 'date formate is not correct'.

The error is 'The required data type is date' . But I do not have the data for the dates, that is i have only month and year. If any formula for this to find quarter from the available data, Please give me the suggestions or any idea to come up. Please do not give any other suggestion like create manually anything.

Thanks and Regards,

Dharani