Last day of a Quarters in a Year in Webi

Hi,

I know it must be simple but missing a logic somewhere to get show Last Day of Quarter of a year.

I have Quarter formula to show "Q1,Q2, Q3 and Q4" and wanted to show Last of day of each quarter.

Quarter formula:

= "Q" + FormatNumber( Floor((ToNumber( [Fiscal Month])- 1)/3)+1; "0")

Tried Todate but getting an #Error.

Appreciate any help.

Thanks,

Jothi