1 Reply Latest reply on Mar 10, 2018 3:58 PM by Eric Hammond

    Two digits in Month

    Sameer N

      Hi

       

      Is there a better way to achieve this?

       

      str(YEAR([Last Email Click Date]))+

      IF    len(str(month([Last Email Click Date])))=1

      THEN Str(0)+STR(month([Last Email Click Date]))

      ELSE Str(month([Last Email Click Date]))

      END

      +str(Day([Last Email Click Date]))

       

      Two parts to this question

      1. I need to convert the date to a format like 20180310 for  date -10/03/2018

      is there a better way to achieve this, than the formula above . i need to store the final value as integer instead of a string.

       

      2.When I use the month function it only gives me single digit  for months 1-9 is there a way i can get 01,02,03 through formula.

       

      Thanks

      Sami