Age calculation with MMDD(x;y)

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Age calculation with MMDD(x;y)

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
  • October 25, 2018 at 2:16 PM #31406

    Anthony Compton
    Participant

    I’m developing an DB for tracking my IT assets (and eventually more) I have added a calculated field to show me the age of the device. This formula correctly returns the number of months old the item is MONTHS(Purchase Date;TODAY()). I would refer to use YYMM(x;y) but this formula returns no value. I have tested other calculations and it appears Years, Months, and Days, all work while YYMM, and YYMMDD return nothing.

    What am I missing?

    October 25, 2018 at 9:45 PM #31410

    Brendan
    Keymaster

    Hi Anthony,

    You may not have set the Result Type to Text for that function.

    I just tested it and it works for me:

    YYMM(Purchase Date;TODAY())

    Returned:

    0 years, 2 months

    October 25, 2018 at 10:02 PM #31412

    Anthony Compton
    Participant

    Yep that was it. I did not notice the result type box. Thanks!

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.