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.