Need to calculate previous months and currrent months GL account

[Hm786]

Hi,

I need some help in calculating previous month's and current month's gl account. For my report I am passing a date parameter based on it I need to calculate 30days, 60days, 90days and 120days gl account. Parameter is associated to the postdate of the report. Like wise I need to calculate the previous month's information. Is there any formula to calculate previous month's date so that I can able to calculate the gl account based on the above day range. Please help me.

Thanks,
Hamida

 

[dgillz]

{Datefield} in MonthToDate

and

{Datefield} in LastFullMonth

Should help you

If you need any more help let me know.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com