Subtracting a whole month to last day of month varied

[former_member584790]

In the following formula if I want to copy this for another month, can I take @End Date which is defined as 4/30/09 and subtract one month from it, that is it would equate to 3/30/09?

If {Command.DOCDATE} in {@Start Date 1} to {@End Date}

then {Command.OXTNDPRC}

else 0

[Former Member · Accepted solution]

Philky,

If you want your @End Date formula to subtract exactly one month then create a formula as such:

DateAdd("m",-1,{@End Date})

I hope this helps,

Regards,

Zack H.