Hello - I need to find the last 6 months data including the current month and when I use the following code, it returns data back to April 30, 2017. I only want to include months - October, September, August, July, June, May (6 whole months). How do I adjust the code to make sure April is not included?
AND calendar_dt >=ADD_MONTHS(CURRENT_DATE,-6)
Solved! Go to Solution.
Well, return all data greater than the last day of the month 6 months ago vs. greater than or equal to the first day of the month 5 months ago.