[SOLVED] how to set a variable to the Last

Focal Point

June 14, 2017, 02:19 PM

tlbrydie

[SOLVED] how to set a variable to the Last

Does anyone have a way to set a variable to the last day of the previous month?

This message has been edited. Last edited by: FP Mod Chuck,

June 14, 2017, 02:39 PM

MartinY

This could be one of the multiple ways:

-SET &CURMTH = EDIT(&DATEYYM, '9999$99') || '01';
-TYPE &CURMTH
-SET &LSTDAYPMTH = AYMD(&CURMTH, -1, 'YYMD');
-TYPE &LSTDAYPMTH

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

June 14, 2017, 02:48 PM

tlbrydie

Thank you very much