(Software Version: 2020.10.23 Database Version: 2020.10.23)
...
Previously, DateTime type columns and fields in the NorthScope 3.0 framework only displayed the date. Time now also displays in an AM/PM format. To specify a DateTime type value, users can utilize a DateTime picker that is configured to format data using the the Date Format User Preference Date Format. Additionally, this DateTime picker allows the selection of specific times, down to the minute. Users also have the option of manually entering the DateTime type value, so long as it is entered using the correct date and time formats. Please note that this fix will not change the way DateTime type columns and fields display on existing framework pages.
Note: There are some limitations to filtering DateTime type fields due to the framework’s inability to parse time. As a result, Quick Filter and filter row text boxes will not properly filter DateTime type columns. However, filtering on a DateTime column can be done by utilizing the “Is after” and “Is before” properties in the Filter menu. When a date is selected using these properties, the system assumes a timestamp of 12:00 AM on the specific date. For instance, to filter all results for 10/2/2020, users may select “Is after 10/2/2020” And “Is before 10/3/2020”. This means all results will be returned between 10/2/2020 12:00 AM and 10/3/2020 12:00 AM.
Technical Changes
No technical changes.