Write an SQL line that pulls the transactions from Jan 1st - Dec 31st 2023 in a formula text field on a transaction saved search

AI generated answer (using internal Slack threads):

To pull the transactions from Jan 1st - Dec 31st 2023 in a formula text field on a transaction saved search, you can use the following SQL line:

sql
CASE 
    WHEN {transaction.trandate} BETWEEN TO_DATE('2023-01-01', 'YYYY-MM-DD') AND TO_DATE('2023-12-31', 'YYYY-MM-DD') 
    THEN 1 
    ELSE 0 
END

This SQL line checks if the transaction date (

{transaction.trandate}

) is between Jan 1st, 2023 and Dec 31st, 2023. If it is, it returns 1, otherwise, it returns 0. Please note that you need to replace

{transaction.trandate}

with the actual field name in your database that represents the transaction date. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******