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

    Formatting a date to include in filename


      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"