Browse Ask a Question
 
Tools
Rss Categories

Can Pathagoras calculate a future date from a given date?

Views: 3157 Created: 08/05/2012 07:10 pm Last Updated: 09/02/2013 03:31 pm 0 Rating/ Voters


Yes. Pathagoras lets you provide a value for a given date variable, and can easily calculate another date based on that value.

1. Method one is semi-manual. Pathagoras does the math, but you have to press the buttons.

Let's assume you have two date variables in your document, one called [Date of Mailing] and the next is called [Deadline Date].

When the document is scanned and the variables are placed into the IDB screen, click the green 'calendar' button next to [Date of Mailing] and, from the resulting screen click on the proper date of mailing. Move down to the [Deadline Date] entry and click the green 'calendar' button there. Select the base date (which likely will still be highlighted). Click the calculator button. The selected date will appear at the top. Select the quantity and the interval you want to add. Click Calculate. Then click Transfer. See this page in the Manual for more.

2. Method two uses a Pathagoras 'mask' (intake form) onto which you have saved the formula.

Let's assume you have two date variables in your document, one called [Date of Mailing] and the next is called [Deadline Date]. Let's assume further that [Deadline date is alway 3 weeks from [Date of Mailing]. In a mask (input form) that you have created for this kind of document, [Date of Mailing] would be placed at the left on one line of the Instant Database screen (a mask is similar to an Instant Database record, and they are created using the same screen) and [Deadline Date] at the left on another line. To the right of [Deadline Date] (in the 'value' column), type =[Date of Mailing] + [3 weeks]. A red box will then appear between the two columns.

When actively used, you will have filled out a date for [Date of Mailing]. Then just click the red button to perform the date math. To do you any good, this form (and the formula) must be saved in a mask so it can be recalled and so you don't have to reenter the formula. See this page in the Manual for more.

3.  Method 3 is automatic and does not require you to create a mask. The formula is 'in-line' (meaning it is contained within the body of the document. And when Pathagoras does this, it is all plain text and facial.)

Let's assume you have a date variable called [Date of Mailing] and you wish to place a variable called (more or less) [Deadline Date]  'in line' that will calculate the date 3 weeks from the [Date of Mailing]. Here is the formula: [#Math#Deadline Date=[Date of Mailing] + [3 weeks]] .

Please note: if you need to repeat [Deadline Date] elsewhere in the document, you can just use [Deadline Date]. You need to set out the formula only once.  See this page in the Manual for more.