How to use a date filter in NuGenesis SDMS WebVision - WKB63723
Article number: 63723
OBJECTIVE or GOAL
Use the date/time filter function in NuGenesis SDMS WebVision.
ENVIRONMENT
- NuGenesis 9 SDMS
- NuGenesis 8 SDMS
PROCEDURE
- Legacy WebVision (NuGenesis 9.3.0 and prior versions, in Internet Explorer or MS Edge in IE Mode):
- In the filter row for the column, enter the DATE() function and, between the parentheses, specify the date in the YYYY-MM-DD format
- Example: DATE(2012-05-14)
- To filter on the current quarter, enter CQUARTER()
- Current month: CMONTH()
- Current year: CYEAR()
- New WebVision (NuGenesis 9.3.0 and later versions, in MS Edge or Google Chrome):
- Click in the filter row for any displayed date column
- A calendar widget will appear
- Select the desired date and WebVision will apply the filter
- NOTE: new WebVision does not support the old filter functions in the user interface. The filter functions are still supported in SDMS project views for backwards compatibility with views made in older versions of NuGenesis
ADDITIONAL INFORMATION
- Legacy WebVision:
- If filtering on the Date/Time of Print column, reports that were printed to the project at the specified date and time are listed
- If filtering on the Date/Time of Database Insertion column, reports that were actually inserted into the project (database) at the specified date and time are listed
id63723, SDMS, SDMS8, SDMS8NU, SUPISDMS, SUPNG