5 Replies Latest reply: Nov 2, 2017 10:43 AM by Yvonne Han RSS

    Most recent 8 months date function

    Yvonne Han

      Hi

       

      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?

       

      Thanks

       

      Yvonne