9 Replies Latest reply: Jul 24, 2015 1:55 AM by Sasidhar Parupudi RSS

    Month Name to Month Number

    Lucille Botha

      Hi guys,


      I have 2 fields that I would like to compare to each other.


      The one field is a period in the format YYYYMM and the other field is a date YYYY-MM-DD.


      I would like to use an expression like

      if(year(date)&month(date) = period, 1, 0)


      but it spits out the month(date) as 'Jan' and not '01'...


      how can I fix this?


      Thank you