Formatting a date to include in filename

Discussion created by DavidCushworth on Jan 9, 2017
Latest reply on Jan 10, 2017 by StephenWonfor

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"