Hello,
I have a Production database (version 9.1) and a Test database (Copy of 9.1 database of Prodcution but running version 9.2), both configured identically in terms of processes and scripts.
However, I'm encountering unexpected behavior with the template script that sets the value for the Person.ExitDate field.
'only if the operator has not set the value manually
If Not Entity.Columns.Item("ExitDate").ChangeLevels.Get(0) Then
If $IsInActive:bool$ AndAlso Not $IsInActive[o]:bool$ AndAlso Not $IsDummyPerson:bool$ _
And ($ExitDate:Date$ = DBVal.MinDate Or $ExitDate:Date$ > Date.Today) Then
Value = Date.Today
ElseIf Not $IsInActive:bool$ AndAlso $IsInActive[o]:bool$ AndAlso Not $IsDummyPerson:bool$ _
And $ExitDate:Date$ <= Date.Today Then
Value = DBVal.MinDate
End If
End If
When creating a new person in Production, the ExitDate is correctly set to DBVal.MinDate (null).
However, in Test, the same action results in ExitDate being set to the end of the day (e.g., 2025-04-29 23:59:59.000), instead of the expected DBVal.MinDate (null).
Both environments are using the same template logic, so I'm unsure why this discrepancy occurs. I’m not certain whether this is a configuration issue, a version-related change, or a bug.
Any guidance or suggestions would be greatly appreciated.
Thank you!
