8 Replies Latest reply on Jan 10, 2017 11:00 AM by StephenWonfor

    Formatting a date to include in filename

    DavidCushworth

      I want to save a particular report as a PDF that includes among other things a date is already stored in the Table.    Trouble is, I call it up and it produces the date with "/" and all.

       

      I have created a variable for  $_Date that uses

       

      Month ( Billing_Info::Sent_Date ) & "_" & Day ( Billing_Info::Sent_Date ) & "_" & Year ( Billing_Info::Sent_Date ) & "_"

       

      This gives me "1_9_2017"

       

      What I would like it to is fill in a leading 0 where possible so it would read  "01092017"

       

      Thanks