Date Calculation Question

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Date Calculation Question

Viewing 2 reply threads
  • Author
    Posts
  • July 6, 2013 at 1:48 PM #6276

    mnmcook
    Participant

    I’m trying to replicate a date calculation from a database I’m porting from Bento. Are there any equivalent date functions that can be used in a calculation field (e.g. “Month()”)?

    July 6, 2013 at 4:23 PM #6280

    Brendan
    Keymaster

    Hello mnmcook,

    There are no date specific functions other than being able to perform basic mathematical calculations on dates. For example [End Date] – [Start Date] will give you the number of seconds between those date fields. Then you can apply a number formatter to the result to display either HH:MM or # hrs, #mins. Or you could do some dividing to get other units that you’re interested in. Adding $now into the formula will put in whatever the current date and time is into the result.

    Thanks,

    Brendan

    July 7, 2013 at 4:57 AM #6282

    mnmcook
    Participant

    AOK, thanks for the quick reply.

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.