ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA View - Will SARGRW Allow Use of an ARCHDATE Range?

book

Article ID: 128830

calendar_today

Updated On:

Products

Deliver View

Issue/Introduction



In using SARGRW to produce reports, does it allow for an ARCHDATE range?
 

Environment

CA View - Releases 12.2 and higher

Resolution

To interrogate the database using a range of ARCHDATE values, use SARGRW code:

 /IF (ARCHDATE GE 'mm/dd/yyyy') AND (ARCHDATE LE 'mm/dd/yyyy')