2 Replies Latest reply: Jul 28, 2015 1:19 AM by Андрей Шепель RSS

    Calculating YTD, YTD prior Year, month in prior Year by field YearMonth

    Андрей Шепель

      Good day!


      in load script i have field YearMonth in format YYYYMM (201507 - July'15)


      I need to create in load script such flags:


      YTD - must get period from beggining of max year till max YearMonth

      YTDPriorYear - the same logic from YTD, but for prior year.

      MTD - max YearMonth

      MTDPriorYear - the same logic from MTD, but for prior year.




      Please, help!