2 Replies Latest reply on Jun 22, 2018 11:40 AM by Don Wise

    Convert Transaction Date

    Farbod Azizi

      Hi, I am looking to create a new Dimension date field where it will take my "Transaction Date" an convert to the first date of that month. For example Transaction Date = "2018-05-22 00:00:00" and the new value will be "5/1/2018"

       

      Once I am able to convert the date, I will use it to match with another report. Any suggestions?