Calculating Report Date Against Current Date

Infogix ACR stores dates as a Date Count. Sometimes, a customer needs to check dates on an input source or a report to determine if the input data is current.

Problem

You want to determine the number of days between a date on a report and the current system date. For example, you want to make sure that a record is less than one year old or that a posted transaction date is less than one day old.

Solution

Infogix ACR stores both the current date and the report date as date counts. Follow the steps below to calculate the report date against the current date.

1 ) To obtain the report date, create a detail field to extract the report date, and specify the date format, such as MMDDYY, in an internal item defined as a date format.

The target detail field must specify the field type and format and must contain the Last Date and the Last Date-Count Value.

2 ) To obtain the current date, set up a calculated item and extract the date using the following equation :

+99999999 >(into) + @DATE

3 ) Create another calculated item to subtract the internal item report date from the calculated current date.

CURRENT DATE -REPORT DATE

4 ) Define a rule, formatted as a count, to analyze the calculated item with the difference in the number of days.