1 Reply Latest reply on Jan 26, 2016 8:46 PM by Shinichiro Murakami

    Filtering to First date in a month for each month in a Year

    Hrishikesh Panchal



      I want to filter first Extract Date from each Period Month for 2015. For e.g. in below image, For the Period Month of Feb'15, i want the first extract date of 20150109 for Jan'15 (month of extract date), same way first extract date of 20150206 from Feb'15 (month of extract date) and so on. have attached a word file showing the same.


      Field "Extract Date" is BIGINT (Type) in the table. Any guidance will be helpful.


      Thank You