Is there a way to make the hardcoded date format-a...
# general
l
Is there a way to make the hardcoded date format-agnostic? the saved search errors out when the user’s preference is set to a different date format: CASE WHEN {status} = ‘Closed’ AND {closedate} <= TO_DATE(‘12/31/2024’, ‘MM/DD/YYYY’) THEN 0 ELSE CASE WHEN ({amount} - NVL({billingtransaction.signedamount}, 0)) < 0 THEN 0 ELSE {amount} - NVL({billingtransaction.signedamount}, 0) END END