5 Replies Latest reply: Dec 1, 2011 10:38 AM by maibangbee RSS

    Date Format

      Hi There

       

      Please help.

       

      At the moment, I am using NUM(month(Today())) to get today's month (11 - which is Nov). however, NUM(month(Today()))-2 will give me Sep (9). How can I convert '9' to '09' as the data from my extract is expecting 09 and not 9.

       

      Thanks