Code for first/last day of last full month? 2

[loveyoursite]

CRV10 - I have a monthly turnover report that has a start date and stop date parameter. I have just found out that in order to schedule the report to automatically run (with the system we are using) the report can not have any user entered parameters. I am having to change my report to “last full month” but all of my running totals used the start and stop date parameters. For example:

{EMPLOYEE.TERM_DATE} >={?Start Date} and
{EMPLOYEE.TERM_DATE} <={?Stop Date} and
{PCODES.CODE} = "03" and
{VW_TERMINATES_REASONS.FIELD_NAME} <> "RESIGNATION"

Everywhere I have used {?Stop Date} now needs to use the last day of the last full month, and the {? Start Date} needs to be the first day of the last full month.

Could someone please help me with a revised formula? I don’t know how to code “last day of the last full month” and “first day of the last full month”. Could you please use the above example in your answer if possible?

Thanks!

 

[Madawc]

You can just get the calendar month: month({your.date}) = month(currentdate)-1

Madawc Williams (East Anglia, UK)

 

[Naith]

{EMPLOYEE.TERM_DATE} >= Minimum(LastFullMonth) and
{EMPLOYEE.TERM_DATE} <= Maximum(LastFullMonth) and
{PCODES.CODE} = "03" and
{VW_TERMINATES_REASONS.FIELD_NAME} <> "RESIGNATION"

 

[loveyoursite]

Excellent, thanks so much Naith, that worked perfectly!

Do you by any chance know the formula for printing that date range? I want to print the date range for whatever the last full month is, for example: May 1, 2005 through May 31, 2005.

Thanks again!

 

[Naith]

ToText(minimum(lastfullmonth),"MMM dd, yyyy") + " through " + ToText(minimum(lastfullmonth),"MMM dd, yyyy")

 

[Naith]

Er, that last bit should read maximum, not minimum.