Dictionary Entry - Function Definition not working

[Navaneeth1]

I have a dictionary entry of type duration for a custom scoped application table. This dictionary entry intends to find the difference between two DateandTime fields. 

I created the same and in the Function definition I entered the code given below:
glidefunction:datediff(resolved_at, opened at)

However, the field shows 0 days 0 hours etc. Is there anything wrong with the code? Does this not work on old/pre-existing records?

The screenshot of the Dictionary Entry is given below: (same image is attached as well)

[tharun_kumar_m]

Hi Navaneeth,

You are right, it won't reflect for the old records. You may need to run a background script or fix script to update for old records.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumbs up.

Best regards,

Tharun Kumar

[saicharan3]

Hi  Navaneeth1

As we can see the Functional Field Code is correct and For this "Does this not work on old/pre-existing records?" -- You need write a Background/Fix Script to update the old records.

[Navaneeth1]

I just checked and it's not working on new records as well. Could you please let me know if there could be any other reason for this not to work?

[tharun_kumar_m · Accepted solution]

Hi Navaneeth,

Please change the code to 

glidefunction:datediff(resolved_at, opened_at)

And in your screenshot the function field is not checked. 

Please configure as same as the below screenshot.

Result:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumbs up.

Best regards,

Tharun Kumar