Formula to Populate 2 Date Fields

[aj3221]

Good morning!
I have a report that needs to have a "Claim Start Date" and a "Claim End Date".

This report currently runs the first day of the month for the LastFullMonth.

Right now I have it emailing to me so I can make the Claim Start Date 20130801 and the Claim End Date 20130831. Is there a way to do that with a formula so I don't have to change it every month to the prior months first/last day?

Thank in advance!

 

[xxyyzz49]

Formula for prior month first of month

dateserial(year(currentdate), month(currentdate) -1, 1);

Formula for prior month end of month

dateserial(year(currentdate), month(currentdate) ,  1 -1 );

 

[aj3221]

That is perfect! Thank you so much!

 

[pmax9999]

An alternative, and perhaps simpler approach would be:

[Code Claim_Start_Date]
Minimum(LastFullMonth)
[/Code]

[Code Claim_End_Date]
Maximum(LastFullMonth)
[/Code]

Cheers
Pete