Updating a Time / Date stamp on a record
RKDMay 16 2011 — edited May 24 2011Hello:
I am currently using the following logic to place a sysdate stamp on a record when it is changed. However, I'd like to update this field each time the record is modifieds. However, the logic I am using is only capturing and retaining the first change date. Can someone please help me to understand how I can overwrite the old information with a current date stamp?
Set the Source of the Item as:
Source Used: "Always, replacing any existing value in session state"
Source Type: "Database Column"
Maintain Session State: Per Session
Source value or expression: Last_Updated_On (This is the name of the DB Column)
Default Value: sysdate
Default Value Type: PL/SQL Expression
Thank you very much for your help.
Regards,
RKD