2 Replies Latest reply on May 9, 2012 1:44 PM by Natalia Gatti

    Formatting string field to date format "YYQQ"

    Natalia Gatti

      Hi,

       

      I'm trying to find a way to convert a string field that I use for fiscal quarters into a date, so I can create a line graph.

      Right now my string format is "YY/Q" being YY the fiscal year and Q the quarter number. For example for 2012: 12/2 - 12/2 - 12/3 - 12/4

       

      Can anyone help me convert that field to a date field? I can change the string format freely if needed (to 2012/01, 2012-1, etc)

       

      Thanks!