If you allow MDY to accept 13 as a valid month then you lose the ability to detect when users have accidentally put the DAY value into the MONTH field. Not sure why the parameters for INTNX are any harder to use than the parameters for MDY or Excel's DATE function. To use those you have first split your dates into three fields. For example if you have your date value in the variable A3 (or the Excel cell reference A3) here is the comparison to calculate the last day of the current month. Excel syntax: =DATE(YEAR(A3),MONTH(A3)+1,DAY(A3))-1 SAS syntax: =INTX('month',A3,0,'end')
... View more