Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Subtracting a whole month to last day of month varied

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 replied


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,


Zack H.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question