AnsweredAssumed Answered

2 digit month and date

Question asked by RichardAdams on Sep 4, 2013
Latest reply on Sep 4, 2013 by RichardAdams


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.