Every Monday I run a query that pulls accts that were opened the previous week but a month ago. For example, yesterday (5/22) I used "acct_open_dt between 4/16/12 and 4/21/12." I need to automate this date range.
What date function do I use?
Thanks for your tremendous assistance.
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.