Calendar and Date Math Features

Instant Database: Calendar and Date Math features

   If Pathagoras detects a variable which includes the word “date” in any form, Pathagoras will display a small green button that will appear between the two columns on the same row as the variable being processed.

   When clicked (optional), Pathagoras will present a calendar from which you can

(1) pick a date and

(2) perform date math (add a certain number of days, weeks, months or years to a starting date).

   Examples of "date" words that will trigger the display of the calendar button:  'Date', 'Birthdate', 'Date of Sale', 'Intimidate' (sorry).

  Screen Shots:

Click to enlarge.

Whenever a variable contains the word 'date' (in any form), a small green button
between the columns will display. Click it to reveal the calendar.
Select a date. (Insert the selected date into the Instant Database screen
by 'double clicking' or pressing the okay button.)
To perform date math, click the Calculator to the right of the calendar overlay.

 

Click to enlarge.

Perform date math by adding or subtracting days, weeks, months or years.
The option 'Expiry date' is one period minus one day to reflect (as do most leases) the last day of the term.

The check-box 'End date must be workday' insures that discovery and other important dates don't fall on weekend.


Notes:

If you have created a mask, you can perform simple date-addition directly on face of the Instant Database screen. See the next section for the steps to set up the formula.

The format for the return value of the date (e.g., "01/01/27", "January 1, 2027" etc.) can be set via the Instant Database Settings Screen. See this link.

You can insert dates in multiple formats from a single entry. See this page for more info.