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

    2 digit month and date

    RichardAdams

      Title

      2 digit month and date

      Post

           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.

           Thanks!