2 Replies Latest reply on Sep 4, 2013 10:05 AM by RichardAdams

    2 digit month and date



      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.