AnsweredAssumed Answered

End of month calculation

Question asked by info@musiktrends.com 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.

Outcomes