You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to subtract 1 second from a datetime value in a Fast Formula?

edited Apr 14, 2026 7:20PM in Payroll and Global Payroll Interface (GPI) 3 comments

How do you subtract 1 second from a datetime value in a Fast Formula?

l_my_text = '12/15/2025 00:00:00'
l_my_datetime = TO_DATE(l_my_text, 'MM/DD/YYYY HH24:MI:SS')
l_one_second_before_my_datetime = ??????

…when it isn't practical to just correct any code that compares against it?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!