We'd like to accurately timestamp information in Viewpoint, and currently the closest we can get is by using either bDate or bTime, both of which use 'smalldatetime' which ignores seconds. This does not work so well if multiple events occur within one minute.
Is there any chance of a 'timestamp' datatype being added which mirrors datetime or datetime2 datatypes from SQL Server?
Thank you.
Nathan Sutherland
| Company | Cutting Edge Plumbing & Mechanical |
| Job Title / Role | Cutting Edge Plumbing & Mechanical |
| I need it... | 3 months |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
Viewpoint, I know this is not high on your priority list, but a way to properly handle fields that contain both a date AND a time would be a huge improvement!
Current workflow for custom table columns: After creating the table in VP, I go into SSMS and modify the column datatype to datetime2(0). Of course I have to redo this whenever the table is changed, but at least I'm capturing seconds!
Perhaps VP could think about adding the 'Precision' for date/time fields?
I'd imagine it going something like:
Or shoot, why not just let us type into the datatype field ourselves? As long as we could specify what kind of control to use (and the hidden data not seen in the control defaulted to the current system info), then I think we'd be fine. :-)
Of course to actually USE datetime fields we'd need a new date + time control, but I'm pretty sure .NET has you covered there.