AnsweredAssumed Answered

Set single digit numbers with a leading zero in calculation

Question asked by JesseH on Sep 9, 2015
Latest reply on Sep 9, 2015 by JesseH

Hello,

I am saving a layout as an Excel worksheet, in my $Path calculation I want to insert a date from a Date Field on my layout. My Date field reads 2015 0909 for September 9th 2015, but in me path it inputs 9/9/2015. i tried breaking it out by getting Year, Month, Day but my result is 2015 99. How would I set single digit numbers to have a leading zero in a calculation?

 

Any help would be aprreciated.

Thanks

Outcomes