Fiscal YTD not working correctly in HCM

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)