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

Fiscal YTD not working correctly in HCM

Accepted answer
11
Views
2
Comments

Summary:

Need to get Fiscal YTD terminations but I cannot get it to result in Sep 1, in instead get 09/22/23 if run today.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

TIMESTAMPADD(SQL_TSI_MONTH, - CASE WHEN EXTRACT(MONTH FROM CURRENT_DATE)>=9 THEN EXTRACT(MONTH FROM CURRENT_DATE) - 8 ELSE 5 - EXTRACT(MONTH FROM CURRENT_DATE) END, CURRENT_DATE)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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