Skip to Content

How Can make coding at PCR based on Effective Date

Nov 10, 2017 at 12:55 PM


avatar image
Former Member

Dear All

i need your help, i make variable at T511K Table Called "ZNCIN" and i filled withe the following values

2 From 16.09.1980 To 15.09.1980

1 From 16.09.2017 To 31.12.9999

and at PCR i write this code




Write Code 1


Write Code 2

my Issue when i run Time Evaluation from 16.10.2017 to 15.10.2017 the system read value 2 which is should read value 1 a per effective date

my question is where is the issue and can any one help me

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Rémi Corriveau Nov 10, 2017 at 05:40 PM

In a Time Evaluation pcr, when you want to query a Constant from Table T511K, you must use HRS=Cxxxxx

Please also double-check the dates of your Constant, since the date don't match:

ZNCIN 16.09.1980 To 15.09.1980 = 2 and 16.09.2017 To 31.12.9999 = 1 You must make sure that your Constant is valid on every day that Time Evaluation could be calculated. If required, create the Constant with the date range and the value 0.00, and modify your pcr to take that value into account.

We use these "Time Stamps" all the time, so we have adopted a Naming Convention where all our Time Stamp Constants have the following structure: ZZYYN, where ZZ identifies the Constant as a Time Stamp, YY indicates the Year, and N is the character that differentiate the Constants created in any given year (we start with numbers 0 to 9, and then move to letters).

Example where constant ZZ17A has value 1 from 01.11.2017 to 31.12.9999:

10 |10000 characters needed characters left characters exceeded