Adding and Subtracting from Date Field

ZP SQL handles dates differently than ZP 32. In ZP SQL all dates are stored in a long DATETIME format that includes both date information and time information. In ZP 32 all dates were stored a simple DATE format. If you want to perform calculations with dates in your ZP SQL reports or documents, you sometimes will need to convert the long DATETIME format to a simpler DATE format first. This is done with the function TTOD( ) - which stands for "Timestamp to Date." So if I want to add 30 days to the Violation Date my report expression would be: TTOD(vio_date) + 30.

Document Editor Text Block Video

I just created a short video that talks just about the process of creating and editing Text objects using the Document Editor. The Document Editor is one of the trickier tools to use in ZonePro so I figure every little tip helps.