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