Current Date vs. Same Date Last Month

[DKirksgirl]

I am writing a report that shows totals for current date and I need totals for the same date last month. How would I write that formula and how would I handle leap year and if the number of days in current month doesn't equal the number of days in last month. If, for instance, if there was a 31st day in this month and last month only has 30, then I would want to display zero for SameDayLastMonth

 

[jjames]

Here's a start...

Create a formula called Day and add the following...

Day ({YourDateField})

Group on this formula

Create another group based on YourDateField

Insert summary on the field you want to total by
YourDateField

Your record select formula or SQL determines how many totals are displayed per day.

 

[CindyN]

Which version of CR are you using? Version 8 has a dateadd function that should work.

DateAdd ("m", -1, {YourDateField})

 

[thomasyu]

For the behaviour of no matching day of the month, try to follow the convention of what DateAdd Does instead of defining your new convention.