<?xml version="1.0" encoding="utf-8"?>
<feed version="0.3"
    xmlns="http://purl.org/atom/ns#"
    xmlns:dc="http://purl.org/dc/elements/1.1/"
    xml:lang="en">

    <title>hotdocs tips</title>
    <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/" />
    <tagline>HotDocs document assembly tips and tricks</tagline>
    <modified>2007-10-28T15:08:09-05:00</modified>
    <generator url="http://www.pmachine.com/" version="1.6.3">ExpressionEngine</generator>
    <copyright>Copyright (c) 2007, Seth</copyright>


    <entry>
      <title>Expression Model: ANSWERED(VAR) and ANSWERED(DIALOG)</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/expression_model_answeredvar_and_answereddialog/" /> 
      <id>tag:hotdocstips.bashasys.info,2007:/7.88</id>
      <issued>2007-10-28T13:48:00-05:00</issued>
      <modified>2007-10-28T15:08:09-05:00</modified>
      <summary>This tip covered the expression models: ANSWERED(VAR) and ANSWERED(DIALOG).&amp;nbsp;  Most often these are used in templates, but they are also used in computations to test whether a variable or a dialog has been answered.&amp;nbsp; Hotdocs scripts will be interrupted if the value of any required variable is not known.&amp;nbsp; For this reason, the  use of the&quot;answered&quot; function gives a value where no value is known.</summary>
      <created>2007-10-28T13:48:00-05:00</created>
		<author>
		  <name>Seth</name>
		  <email>sgr@bashasys.com</email>
		  <url>http://www.bashasys.com</url>		</author>
      <dc:subject>computations, expression models</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<p><b>What are the elements?</b>
<br />
- ANSWERED: The function
<br />
- VAR: Any variable.&nbsp; All variables will have an &#8220;answered&#8221; or &#8220;unanswered&#8221; status.&nbsp; Note, that you can force an answered status on a variable under two conditions: (1) if the variable has a &#8220;default&#8221; and the dialog on which the variable appears has been asked, or (2) the variable is a True/False variable on a dialog with an Ask All setting and that dialog has been asked.
<br />
- DIALOG: Any dialog.&nbsp; This tests whether the dialog has been &#8220;asked&#8221; in an interview.&nbsp; 
</p>
<p>
<b>Usage of ANSWERED expression:</b>
<br />
- Usage is disparaged by the software developers as &#8220;unnecessary&#8221;.&nbsp; A properly designed template should have sufficient nesting of logic such that you need not test whether a particular variable has been answered.&nbsp; This is particularly true when you use variable in IF EXPRESSIONS.
<br />
- It is also disparaged because the way HotDocs does (or rather does NOT) clear data.&nbsp; If a variable is &#8220;hidden&#8221; based on a dialog scripting rule, the hidden variable still retains its value.&nbsp; For this reason, you should not depend on the answered status of a variable to determine whether a phrase should be included if there are parent conditions not expressed in the template.
<br />
- Usage is recommended if you want something special to happen, other than the ordinary, if a variable has not been answered.&nbsp; While you can use &#8220;tokens&#8221; in the advanced properties of a variable, you may want to put the rules into a computation.
</p>
]]></content>
    </entry>

    <entry>
      <title>Instruction Model: AGE(DATE)</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/instruction_model_agedate/" /> 
      <id>tag:hotdocstips.bashasys.info,2007:/7.87</id>
      <issued>2007-10-17T18:49:01-05:00</issued>
      <modified>2007-10-17T19:56:12-05:00</modified>
      <summary>This tip covers the instruction model: AGE(DATE).&amp;nbsp; Use this expression if you want to know the age in terms of years as of the current date.&amp;nbsp;  If you want to know the age as of a specific date, other than today, then you will need to use YEARS FROM( DATE , DATE )</summary>
      <created>2007-10-17T18:49:01-05:00</created>
		<author>
		  <name>Seth</name>
		  <email>sgr@bashasys.com</email>
		  <url>http://www.bashasys.com</url>		</author>
      <dc:subject>computations, instruction models</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<h4>What are the elements?</h4><p>
- AGE: The function
<br />
- DATE: The start date for measuring the age.&nbsp; It can be a birth date or the date a debt was incurred.
</p>
<h4>How do you use it?</h4><p>
</p><div class="codeblock"><code>
<span style="color: #0000CC">AGE</span><span style="color: #006600">(</span><span style="color: #0000CC">CLIENT&nbsp;Date&nbsp;of&nbsp;Birth&nbsp;DA</span><span style="color: #006600">)</span><span style="color: #FF9900"></span>
</code></div><p>
</p>]]></content>
    </entry>

    <entry>
      <title>Instruction Model: ABSOLUTE VALUE(NUM)</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/instruction_model_absolute_valuenum/" /> 
      <id>tag:hotdocstips.bashasys.info,2007:/7.86</id>
      <issued>2007-10-17T18:35:00-05:00</issued>
      <modified>2007-10-17T19:48:10-05:00</modified>
      <summary>This tip covers the instruction model: ABSOLUTE VALUE(NUM). This model returns the positive (or absolute) value of a number variable.&amp;nbsp; In some accounting formulas, the result of the formula will be a negative number.&amp;nbsp; You may want to not the value as a negative, but still be able to treat and format the number based on its positive value</summary>
      <created>2007-10-17T18:35:00-05:00</created>
		<author>
		  <name>Seth</name>
		  <email>sgr@bashasys.com</email>
		  <url>http://www.bashasys.com</url>		</author>
      <dc:subject>computations, instruction models</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<h4>What are the elements?</h4><p>
- ABSOLUTE VALUE: The function
<br />
- NUM: A number value, positive or negative
</p>
<h4>How do you  use it?</h4><p>
<i>Use it in a fillpoint or computation for a variable entered in the system</i>
<br />
</p><div class="codeblock"><code>
<span style="color: #0000CC">ABSOLUTE&nbsp;VALUE</span><span style="color: #006600">(</span><span style="color: #0000CC">Profits&nbsp;NU</span><span style="color: #006600">)</span><span style="color: #FF9900"></span>
</code></div><p>
</p>
<p>
<i>Use it to test the result of a calculation</i>
<br />
</p><div class="codeblock"><code>
<span style="color: #0000CC">ABSOLUTE&nbsp;VALUE</span><span style="color: #006600">(</span><span style="color: #0000CC">Gross&nbsp;Revenue&nbsp;NU&nbsp;</span><span style="color: #006600">-&nbsp;</span><span style="color: #0000CC">Expenses&nbsp;NU</span><span style="color: #006600">)</span><span style="color: #FF9900"></span>
</code></div><p>
</p>]]></content>
    </entry>

    <entry>
      <title>Instruction Model: ZERO(NUM)</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/zero_computations/" /> 
      <id>tag:hotdocstips.bashasys.info,2007:/7.85</id>
      <issued>2007-10-17T18:16:00-05:00</issued>
      <modified>2007-10-17T19:46:41-05:00</modified>
      <summary>This tip covers the use of the instruction model: ZERO(NUM).&amp;nbsp; When is a number not a number?&amp;nbsp; When it has no value.&amp;nbsp; That doesn&#8217;t present an issue unless you start running calculations based on an unanswered number.&amp;nbsp; The solution is ZERO(NUM).</summary>
      <created>2007-10-17T18:16:00-05:00</created>
		<author>
		  <name>Seth</name>
		  <email>sgr@bashasys.com</email>
		  <url>http://www.bashasys.com</url>		</author>
      <dc:subject>computations, instruction models</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<p>What ZERO expression does is return the number value (if there is a number) or zero.
</p>
<h4>Use for a sum of different number variables</h4><p>
SET Fruit Total NU TO ZERO(Apples CNT) + ZERO(Oranges CNT) + ZERO(Tangerines CNT) 
</p>
<h4>Use to provide a Total off a Repeat</h4><p>
0
<br />
REPEAT Inventory RPT
<br />
SET RESULT TO RESULT + ( ZERO(Item CNT) * ZERO(Item Price NU) )
<br />
END REPEAT
</p>]]></content>
    </entry>

    <entry>
      <title>Correcting Bloated Images in RTF Templates</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/correcting_bloated_images_in_rtf_templates/" /> 
      <id>tag:hotdocstips.bashasys.info,2007:/7.81</id>
      <issued>2007-04-28T16:57:01-05:00</issued>
      <modified>2007-04-28T18:10:48-05:00</modified>
      <summary>HotDocs, DealBuilder and GhostFill all work with RTF Templates.&amp;nbsp; On occasion, a template may include an image for a watermark, a logo, or some other purpose.&amp;nbsp; Thanks to an ingenious feature of Word, when you some a document to rich&#45;text format (RTF) the images are converted to a useless, but huge windows metafile.&amp;nbsp; This ensures compatability with ANCIENT word processors, but does nothing for you.&amp;nbsp; In fact, a simple company logo can expand the size of a short letter from 20K, to 1,200K (or 1.2 MB).&amp;nbsp; And that is before you start adding text.&amp;nbsp; The solution is a simple change in the registry for WORD on each machine.&amp;nbsp;</summary>
      <created>2007-04-28T16:57:01-05:00</created>
		<author>
		  <name>Seth</name>
		  <email>sgr@bashasys.com</email>
		  <url>http://www.bashasys.com</url>		</author>
      <dc:subject>templates, rich text format (RTF)</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<p>To keep Word from saving two copies of the graphic in your template:
<br />
<ul>
<li>Close Word (if it&#8217;s running.)</li>
<li>Click Start > Run . The Run dialog box appears. </li>
<li>In the Open box, type regedit and click OK. The Registry Editor opens.</li>
<li>Navigate to HKEY_CURRENT_USER > Software > Microsoft > Office > Version > Word > Options. (Replace Version with the version of Word you are using.)</li>
<li>In the right pane of the window, right-click and choose New > String Value. A new string is created called New Value #1. </li>
<li>Rename the value to ExportPictureWithMetafile. (To do this, you can choose Rename from the shortcut menu.)</li>
<li>Once the name is changed, right-click on the string and choose Modify. The Edit String dialog box appears.</li>
<li>In the Value data box, enter 0. </li>
<li>Click OK.</li>
</ul>
<br />
Now, you need to remove the graphics (save them to another document if you have more than one). Then save the document without the graphics.&nbsp; You should exit Word and then restart it.&nbsp; Now paste your images back in.&nbsp; Check the file size.
<br />

</p>]]></content>
    </entry>

    <entry>
      <title>Limit Spreadsheet Lines Appearing</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/limit_spreadsheet_lines_appearing/" /> 
      <id>tag:hotdocstips.bashasys.info,2007:/7.75</id>
      <issued>2007-02-22T00:50:01-05:00</issued>
      <modified>2007-02-22T00:50:50-05:00</modified>
      <summary>You want to control the number of lines that appear on a dialog that displays in &#8220;Spreadsheet&#8221; style.&amp;nbsp; Quite often, the default number of lines visible on a spreadsheet style dialog are aesthetically offensive. We need to control this for two reasons: 1) its ugly; and 2) screen real estate is quite often at a premium.</summary>
      <created>2007-02-22T00:50:01-05:00</created>
		<author>
		  <name>Admin</name>
		  <email>ibb@bashasys.com</email>
		  		</author>
      <dc:subject>code snippets, repeats</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<p>Basha Systems use a CNT prefix for specific purpose number variables, to differentiate between a &#8220;true&#8221; number variable used in document assembly templates, and those number variables used for tracking, counting &amp; limiting. Lets presume we are dealing with a spreadsheet to enter in children&#8217;s names and DOB&#8217;s. In the dialog PRIOR to the spreadsheet dialog relating to children, create a variable something similar to Var_CNT. The prompt should be something like &#8220;How many children do you wish to enter?&#8221; In the script of the spreadsheet dialog, place the following: 
</p>
<p>
LIMIT Var_CNT
</p>
<p>
This will ensure that the spreadsheet is LIMITed to the number of lines that the user has indicated are required. You may wish to REQUIRE the Var_CNT variable, so the user must enter a number to gain access. 
</p>
<p>
If the spreadsheet dialog is actually &#8220;Spreadsheet on Parent&#8221;, you should script the dialog so that it doesn&#8217;t even appear until such time as the Var_CNT variable has been answered. Using this approach, the REQUIRE option is redundant.&nbsp;
</p>]]></content>
    </entry>

    <entry>
      <title>Instruction Model: ADD TEXT TO MULT_CHOICE</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/instruction_model_add_text_to_mult_choice/" /> 
      <id>tag:hotdocstips.bashasys.info,2006:/7.69</id>
      <issued>2006-12-28T17:06:01-05:00</issued>
      <modified>2007-10-17T19:49:40-05:00</modified>
      <summary>This tip covers when to use and how to use the HotDocs Instruction Model: ADD TEXT TO MULT_CHOICE.&amp;nbsp; HotDocs supports dynamic multiple choice variables.&amp;nbsp; A list of options (and their associated prompts) for a multiple choice variable can be seen in the definition of a particular component. However, this restricts the user to options known at the time that a component file is authored. This instruction model lets the developer dynamically change the option values and their associated prompts based on answers given by the user during an assembly.</summary>
      <created>2006-12-28T17:06:01-05:00</created>
		<author>
		  <name>Seth</name>
		  <email>sgr@bashasys.com</email>
		  <url>http://www.bashasys.com</url>		</author>
      <dc:subject>computations, instruction models</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<h4>What are the elements?</h4><p>
- ADD: The instruction to Add Text
<br />
- TEXT: A Text Value, a Text Variable,  or a Text String consisting of Text and Variables
<br />
- MULT_CHOICE: A Multiple Choice Variable (Single select and Multi-Select)
</p>
<h4>Other Related Instructions?</h4><p>
- CLEAR MULT_CHOICE:&nbsp; Will clear ALL options and prompts for a Multiple Choice Variable
</p>
<h4>How do you  use it?</h4><p>
<i>1. Build from a Repeat</i>
<br />
The sample below is used to set the options for a Beneficiary selector.&nbsp; This option could itself appear on a REPEAT.&nbsp; The beneficary variable is first CLEARed. Then the script loops through the list of children, adding each child&#8217;s name, one at a time to the option list.
<br />
</p><div class="codeblock"><code>
<span style="color: #0000CC">CLEAR&nbsp;BENEFICIARY&nbsp;Name&nbsp;MC<br />REPEAT&nbsp;CHILDREN&nbsp;RPT<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ADD&nbsp;CHLD&nbsp;Name&nbsp;TE&nbsp;TO&nbsp;BENEFICIARY&nbsp;Name&nbsp;MC<br />END&nbsp;REPEAT</span><span style="color: #FF9900"></span>
</code></div><p>
</p>
<p>
<i>2. Build from a Script</i>
<br />
The sample below is used to set the options for a Beneficiary selector.&nbsp; This option could itself appear on a REPEAT.&nbsp; The beneficary variable is first CLEARed. Then the script loops through the list of children, adding each child&#8217;s name, one at a time to the option list.
</p>
<p>
</p><div class="codeblock"><code>
<span style="color: #0000CC">CLEAR&nbsp;CLI&nbsp;Married&nbsp;MC<br />ADD&nbsp;</span><span style="color: #CC0000">"Married|Client&nbsp;is&nbsp;married"&nbsp;</span><span style="color: #0000CC">TO&nbsp;CLI&nbsp;Married&nbsp;MC<br />ADD&nbsp;</span><span style="color: #CC0000">"Single|Client&nbsp;is&nbsp;single"&nbsp;</span><span style="color: #0000CC">TO&nbsp;CLI&nbsp;Married&nbsp;MC<br />ADD&nbsp;</span><span style="color: #CC0000">"Divorced|Client&nbsp;is&nbsp;divorced"&nbsp;</span><span style="color: #0000CC">TO&nbsp;CLI&nbsp;Married&nbsp;MC<br />ADD&nbsp;</span><span style="color: #CC0000">"Widowed|Client&nbsp;is&nbsp;widowed"&nbsp;</span><span style="color: #0000CC">TO&nbsp;CLI&nbsp;Married&nbsp;MC</span><span style="color: #FF9900"></span>
</code></div><p>
</p>
<p>
<i>3. Build from a Repeat and Add Custom Prompt</i>
<br />
The sample below is used to set the options for a list of children to disinherit from a will.&nbsp; The variable is first CLEARed. Then the script loops through the list of children.&nbsp; For the option value, it adds each child&#8217;s name.&nbsp; However, for the prompt, it puts in the child&#8217;s relationship to the , one at a time to the option list.
</p>
<p>
</p><div class="codeblock"><code>
<span style="color: #0000CC">CLEAR&nbsp;HEIR&nbsp;Disinherit&nbsp;Name&nbsp;MS<br />REPEAT&nbsp;CHILDREN&nbsp;RPT<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #FF9900">//&nbsp;Change&nbsp;prompt&nbsp;based&nbsp;on&nbsp;gender&nbsp;of&nbsp;child<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #006600">IF&nbsp;</span><span style="color: #0000CC">CHLD&nbsp;Gender&nbsp;MC&nbsp;</span><span style="color: #006600">=&nbsp;</span><span style="color: #CC0000">"Male"<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000CC">ADD&nbsp;</span><span style="color: #CC0000">"«CHLD&nbsp;Name&nbsp;TE»|Client's&nbsp;son&nbsp;«CHLD&nbsp;Name&nbsp;TE»"&nbsp;</span><span style="color: #0000CC">TO&nbsp;HEIR&nbsp;Disinherit&nbsp;Name&nbsp;MS<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #006600">ELSE<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000CC">ADD&nbsp;</span><span style="color: #CC0000">"«CHLD&nbsp;Name&nbsp;TE»|Client's&nbsp;daughter&nbsp;«CHLD&nbsp;Name&nbsp;TE»"&nbsp;</span><span style="color: #0000CC">TO&nbsp;HEIR&nbsp;Disinherit&nbsp;Name&nbsp;MS<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END&nbsp;</span><span style="color: #006600">IF<br /></span><span style="color: #0000CC">END&nbsp;REPEAT</span><span style="color: #FF9900"></span>
</code></div><p>
</p>]]></content>
    </entry>

    <entry>
      <title>SET Command and GRAYed Variables</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/set_command_and_grayed_variables/" /> 
      <id>tag:hotdocstips.bashasys.info,2006:/7.76</id>
      <issued>2006-12-14T00:50:00-05:00</issued>
      <modified>2007-02-22T01:44:20-05:00</modified>
      <summary>You need to SET the value of a variable, but want users to be able to edit the value even after it is SET.&amp;nbsp; HotDocs will GRAY a variable (prohibiting editing) if the SET command is processed on the dialog, and DEFAULT will not overwrite a variable&#8217;s value.


A &#8220;regular&#8221; script to SET a variable to a value (based upon a Multiple Choice variable) probably looks something like this:


IF ANSWERED ( Var_MC )

IF Var_MC = &#8220;1&#8221;

SET Var1_TE TO &#8220;red&#8221;

ELSE

SET Var1_TE TO &#8220;blue&#8221;

END IF

END IF 


As soon as Var_MC is answered, Var_TE will acquire an appropriate value, and subsequently GRAYed out &#45; because it is processed dynamically by the dialog script, and whilever those conditions are met, the variable will not be editable.&amp;nbsp;</summary>
      <created>2006-12-14T00:50:00-05:00</created>
		<author>
		  <name>Admin</name>
		  <email>ibb@bashasys.com</email>
		  		</author>
      <dc:subject>code snippets, dialog handling</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<p>We need to avoid HotDocs GRAYIng the variable. The solution? A button that calls a computation.
</p>
<p>
Lets say we create a variable called Var1_CO - this is the variable that will be called by the button on our dialog. The content of this computation will be exactly the same as the script above. We don&#8217;t wish to do anything different, we just wish to shift the source of the SET command.
</p>
<p>
In our dialog additional text section, we type
</p>
<p>
@COMPUTE:Var1_CO: Populate
</p>
<p>
@COMPUTE is the command to tell HotDocs we want a button to call a computation. Var1_CO is the name of the computation variable we are calling. Populate is the button text which will be displayed. When we click this button, the value is SET (provided all conditions have been made), and the variable is editable.&nbsp;
</p>]]></content>
    </entry>

    <entry>
      <title>Adding Spacing to Dialog Elements</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/adding_spacing_to_dialog_elements/" /> 
      <id>tag:hotdocstips.bashasys.info,2006:/7.66</id>
      <issued>2006-12-07T20:00:00-05:00</issued>
      <modified>2006-12-07T21:08:39-05:00</modified>
      <summary>When working with Dialog Elements, particularly Horizontal Lines, you may wish to add a line (or vertical space) before the dialog element.&amp;nbsp; You COULD add a separate dialog element for the spacing. But that adds to your scripting and dialog management.&amp;nbsp; Instead, you should add a  Code before and after the Prompt for the Dialog Element.</summary>
      <created>2006-12-07T20:00:00-05:00</created>
		<author>
		  <name>Seth</name>
		  <email>sgr@bashasys.com</email>
		  <url>http://www.bashasys.com</url>		</author>
      <dc:subject>dialogs</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<ul>
<li>Create the Dialog Element</li>
<li>Set to Horizontal Line</li>
<li>Choose Alignment:&nbsp; Left/Center/Right</li>
<li>In the Prompt, Right-click and add a Paragraph Marker</li>
<li>Type your prompt</li>
<li>At the end, Right-click and add another Paragraph Marker</li>
</ul>]]></content>
    </entry>

    <entry>
      <title>Convert Time Matters Date to a HotDocs Date</title>
      <link rel="alternate" type="text/html" href="http://hotdocstips.bashasys.info/index.php/hotdocs/convert_time_matters_date_to_a_hotdocs_date/" /> 
      <id>tag:hotdocstips.bashasys.info,2006:/7.74</id>
      <issued>2006-10-17T00:47:01-05:00</issued>
      <modified>2007-02-22T01:44:04-05:00</modified>
      <summary>Dates in Time Matters display as Dates on the Matter form. But, they are actually stored as Numbers. When you bring them into HotDocs via the Database Connection or Active Integration, you get a number, and not a date. This solution is courtesy of Bart Earle.&amp;nbsp;  Dates are stored as the number of Days from December 28, 1800. The solution is to create a computation that takes that number and converts it into a date that can be used and formatted by HotDocs.&amp;nbsp;</summary>
      <created>2006-10-17T00:47:01-05:00</created>
		<author>
		  <name>Admin</name>
		  <email>ibb@bashasys.com</email>
		  		</author>
      <dc:subject>code snippets, integration &amp; databases</dc:subject>
      <content type="text/html" mode="escaped" xml:lang="en-US"><![CDATA[<p>Create a compuation variable such as Convert Date CO. The formula gets the number of days from December 28, 1800 and subtracts that from the number from the TM database. 
</p>
<p>
TODAY + (TMBaseDateNU - (DAYS FROM (DATE OF(28,12,1800),TODAY))) DAYS
</p>
<p>
The result will be negative if TMBaseDateNU references a date in the past. It then adds that result to TODAY, in effect counting backward or forward from TODAY to figure out the date.
</p>]]></content>
    </entry>


</feed>