HotDocs Tips & Tricks

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.  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. 

Quite often, you’ll want to dynamically create the options of a multiple choice variable from a repeating dialog (or other source).  This HotDocs snippet will detail how you can do that.  The concept is simple - if you ADD an option to the MC variable, you also accumulate the ADDed value in a text string, so that you can test against that string later.  Then, each iteration, you test whether the current value you may wish to add already exists in the text string and if it does, you do NOT ADD it.  If it does NOT exist, you ADD it to the MC variable, and also to the text string.