HotDocs Tips & Tricks

Have you ever tried to add an Access database as a new “datasource” in Vista64 and Windows7? In most cases, you will go WINDOWS START -> Control Panel -> Administrative Tools -> Data Sources (ODBC).  When you click ADD, you will get SQL Native Client and SQL Server.  There will be NO opportunity to add Access or any of the OLDER data types.  These 32-bit datatypes are effectively banished from the system.  Quelle disaster!!!  Well we have a solution, one that is REAL EASY

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.