Instant Database: Date 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:

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 by 'double clicking' or pressing the okay button.
To perform date math, click the Calculator to the right of the calendar overlay.

 

If needed, 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.

   Set the format for the return value (e.g., "01/01/07", "January 1, 2007" etc., via the Instant Database Settings Screen. See this link.

Page url: http://www.pathagoras.com/help/index.html?date_and_math_features.htm