Need Query to Output as Date

Need Query to Output as Date

Hi,
I'm new to Zoho/queries.....In my formula below, I need "23-24 Start Date" to output in a date format, but when i try to change the data type after I execute my query, it says it's not compatible. How do I fix that?

SELECT
"Staff Demographic Data Historical"."Department",
"Staff Demographic Data Historical"."First Name",
"Staff Demographic Data Historical"."Original Hire Date",
 
CASE
WHEN "Staff Demographic Data Historical"."Department"  = '1000-Central Office Staff' THEN TO_DATE('2023-07-31', 'YYYY-MM-DD')
WHEN "Staff Demographic Data Historical"."Original Hire Date"  > '2023-07-01' THEN "Staff Demographic Data Historical"."Original Hire Date"
ELSE DATE_ADD("Staff Demographic Data Historical"."Original Hire Date", INTERVAL (business_days("Staff Demographic Data Historical"."Original Hire Date", today(), 1)) DAY)
END AS "23-24 Start Date"
FROM  "Staff Demographic Data Historical"