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)
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.