8 Replies Latest reply on Apr 26, 2018 10:33 AM by Shinichiro Murakami

    date conversion

    Robin Fay

      Hey Everyone,

       

      I'm trying to figure out how to convert 3 fields in my data set to a date (week begin date)

      all my weeks end on Saturday

      for example week 1 for Jan 2018 would be 12/13/17 - 1/6/18. All I want to see is "1/6/18"

       

      my data looks like this (also attached)

       

      F MonthF WeekF Year
      Jan12018
      Jan22018
      Jan32018
      Jan42018
      Jan12017
      Jan22017
      Jan32017
      Jan42017