Assistance Needed for Date Difference Calculation in OFSC

Hello Team,

We are currently receiving a date value in one of the string properties in the format MM/DD/YY HH

The requirement is to calculate the difference between this date value and the current system date in hours, and store the result in a new property. This new property is intended to be utilized in one of the Filters.

Here are the challenges we’re facing:

1. Calculating the difference in hours using Screen Configuration/Default Values, specifically with the received date and the current date (via now()).
2. If we manage to implement the calculation, we also need to establish an automated method to update this new property for all activities, ensuring it is consistently available for use in Filters.