9 Replies Latest reply on Sep 12, 2018 2:58 PM by totolo

    Copy a date field and replace/rectify a month with another month

    totolo

      Hello,

       

       

      I would like to copy a date field and replace/rectify all the values "November" with the value "October" and that doesn't matter the year (we want to aggregate all the profit in October). I tried some calculated fields without success.

      Indeed the result is always a discrete field and i  loses all the logic of a date field (hierarchy). It is therefore impossible to draw a nice curve without sorting manually.

       

      It doesn't seem complicated to do in sql, the problem is that I don't have the right to write in the database.

       

      Do you have any solutions or clues?

       

      Yours sincerely

      Capture.PNG