6 Replies Latest reply on Sep 19, 2016 6:51 AM by kettan

    How do I take Year-Month only from this complicated Date String?

    Yawei Lyu

      I am trying to make a diagram to show total sales "over time".

       

      The order date shows me a string like this "02-FEB-06 01.34.56.345678000 AM". I've tried to write calculations to reformat it or take the year-month from it but all fails.

       

      What should i do to change this into simple Year-Month format like "06-FEB"?

      Do I need to change the data type from string to Date or DateTime?

      How do I write the calculation if I need one?

       

      Thank you all!