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!

       

      Thanks.