18 Replies Latest reply: Aug 2, 2012 9:05 AM by Steven Bain RSS

    Month()/Day() Functions with Leading Zeros?

    Steven Bain

      Hiya Guys,

       

      I am writing a user-defined function in a Macro and require Months and Days in the format of "00".

       

      I assume that, as I am running the function from a Load Script, the following line of code does not work:

      MakeDateKey = ActiveDocument.Evaluate("Num(Year(dat),'0000') & Num(Month(dat),'00') & Num(Day(dat),'00')")

       

      So how do I convert/format the following so that Month() and Day() will always return a 2-digit number?:

       

       

      Cheers,

       

      Steve.

      MakeDateKey = Year(dat) & Month(dat) & Day(dat)