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)

[Navaneeth1]

@tharun_kumar_m 
Thank you so much for the response. The function field with the check box is read-only for some reason. Is there a reason why it's like this? 

[tharun_kumar_m]

@Navaneeth1 ,

I'm also not able to change it once I saved it, please try to delete and create a new field.

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

Best regards,

Tharun Kumar

[Navaneeth1]

The form doesn't let me go to advanced view (Which has the function field checkbox) unless the form gets saved and it's still read only.

[tharun_kumar_m]

Hi Navaneeth, 

You don't need advanced view for marking function field as true. I have verified in both Utah and Vancouver versions.

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

Best regards,

Tharun Kumar

[Navaneeth1]

Hey @tharun_kumar_m ,

The field was missing and I added it from form configuration and it worked! Thank you so much for all the help! I truly appreciate it! :))