2 Replies Latest reply: Jul 21, 2015 3:15 AM by Prashant Sangle RSS

    Filter Date while Loading From Database

    Amith Murali

      Hi guys,

       

      I have a Problem in my DB. When i load the data from 2014. in some places, because of the user error. there some dates like 2090,2030 etc and also months.

       

      How to filter data while loading from 2014 jan 1st to Todays date.

       

      This is the filter which i used while loading the data to get data from 2014 jan1st.

       

      FROM cmsdhcc.dbo."department_income_view"  where YEAR("d_date") >=2014;