2 digit month and date
Hi... I am trying to create a calculation that displays the date as YYMMDD (ie: 130904 for 9/4/2013)...
This is just for a variable for saving an excel sheet to match our current date system for files on our computer (not for storing dates in filemaker fields).
I got the year to 2 digits with: Year (Get(CurrentDate)) - 2000
But, since Month and Day functions output 1 for January instead of 01, I am unsure of how to only tack on the 0 for months 1-9 using a calculation.