12 Replies Latest reply: Mar 12, 2018 10:45 AM by Michael Tarallo RSS

    Loading past 10 months data

    Baarathi V

      Load *;

      SQL Select *

      from DM.Da

      Where monthstart(CreatedDate,'YYYY-MM-DD')  >= Date(monthstart(dateadd(month,-10,Today(),'YYYY-MM-DD'));

       

      this statement throws an error, monthstart is not avaible in sql server. How can i load data for past 10 months ?