formula (currency) Case When to get the last year (1/1/2023) till the same date last year ( 8/25/2023) to date amount in a saved search

AI generated answer (using internal Slack threads):

Based on the conversations, you can use a formula (currency) case when to get the last year (1/1/2023) till the same date last year (8/25/2023) to date amount in a saved search. You can use a formula similar to the one below:

sql
CASE 
    WHEN {transaction.trandate} BETWEEN TO_DATE('01/01/2023', 'MM/DD/YYYY') AND TO_DATE('08/25/2023', 'MM/DD/YYYY') 
    THEN {amount} 
    ELSE 0 
END

This formula checks if the transaction date is between 1/1/2023 and 8/25/2023. If it is, it returns the transaction amount; otherwise, it returns 0. Please note that you need to replace

{transaction.trandate}

and

{amount}

with the actual fields in your saved search. Also, the date format 'MM/DD/YYYY' should be replaced with the date format used in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******