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.