Current Position:Home > NWP1 Current date

NWP1 Current date

Update:11-30Source: network consolidation
Advertisement
Hi experts,
Basis has recently change the time in the system to terminate daylight savings, after that, the date in transaction NWP1 that is setting in variant attributes as current date, instead of current day the system shows the date of a day before from 00:00 to 01:00 showing incorrect list of patients, after this time, the date is corrected.
Sounds like a program error, or is there some extra configuration to make for this transacction in order to take the correct current date?
The date in other transactions is ok, for example NR16.  ISH 6.0 Level 0018
Thanks in advance.

The Best Answer

Advertisement
I found the answer to my issue. The initialization block used the following string:
select JULIAN_DAY_NUM, YEAR_AGO_DT , ROW_WID
from VALUEOF(OLAPTBO).W_DAY_D WHERE to_date(DAY_DT)=to_date(SYSDATE - VALUEOF(TIME_OFFSET))
Apparently I did not define the OLAPTBO variable so it was not updating correctly. After I defined this variable, my current dates are now correct.

Recommended Content

Database error: [Table 'ac_posts' is marked as crashed and should be repaired]

SELECT * FROM ac_posts WHERE `ID` IN (1503769,2888533,550830,4409322,3809259,737125,891174,2800978,2940278,3348407,1571563,609656,1131574,2297004,680954,3596361,1653456,2467566,971897,783788,2606775,2187466,2387165,4446879,1557005,3071364,826675,3774504,4341586,3499497,1237382) LIMIT 15;