I have a date field [Start Date], and I want to load only records with start date in the most recent 8 months, including current month. For example, for any date in November, I need to load records from Apr. 1st till Nov. 30th. I'm using this expression
"where [Start Date]>=AddMonths (monthend(today()), - 8);" in load script, but I got Mar. 31st loaded. Any idea why?