AnsweredAssumed Answered

End of month calculation

Question asked by on Dec 1, 2017
Latest reply on Dec 1, 2017 by beverly

Hi everyone. I'm trying to calculate the end of the pay period (PPEndID_FK) by using the PPBeginID_FK field. I couldn't find a native function in FM that calculates it so I tried this calculation:


ExecuteSQL ("SELECT eomonth(PPBeginID_FK)

FROM OfficeAndProductionTSheets

WHERE PPBeginID_FK=?"; "" ; "" ; GetAsDate ( PPBeginID_FK ))


The field is formatted as date yet the result displayed is "?".


I'm trying to achieve this result:

PP Begin = 1/16/17

PP End = 1/31/17


Any help would be greatly appreciated.