Best way to create a crystal formula to get the prior month last day date 1

[jchewsmith]

I am trying to find a fiscal year to date selection.

I have the forumla to get the fiscal year begin date but I need a formula to get the last day of the previous month end.

So if I run report on 7/5, it runs through 6/30
or if I run the report on 4/28 it run through 3/31.

 

[pmax9999]

The simplest approach is to subtract 1 day from the 1st of the current month, ie:

DATE(Year(CurrentDate), Month(CurrentDate), 1) - 1

Hope this helps.

Cheers
Pete