Skip to main content
Aug 26, 2025 6:36 PM UTC
Question

calculating datediff for a report

Creating a very simple Project report to show dates at project level and weekday difference between them. Two dates listed for the project are custom form dates - PredicationStart and PredicationEnd. But, my attempt to show the weekday difference is turning futile. What am I missing?

Valueexpression=WEEKDAYDIFF({DE:PredicationEnd}, {DE:PredicationStart})
displayname=Weekday Difference
valueformat=HTML

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

5 replies

KellieGardner
Community Advisor
Community Advisor
Aug 26, 2025 8:38 PM UTC

You need to lowercase the "valueexpression".

 

Additionally, the custom fields should maintain their formatting as they are setup in your system likely with spaces like this:

 

valueexpression=WEEKDAYDIFF({DE:Predication End}, {DE:Predication Start})

 

Translate
Aug 26, 2025 8:48 PM UTC

Thanks, Kellie. I did have everything in lowercase and it was still not working. So, I just added a calculated field in the custom form itself and then added that in the report. I wanted to avoid taking the extra step if there was a way to directly calculate the difference in the report.

Translate
KellieGardner
Community Advisor
Community Advisor
Aug 26, 2025 11:03 PM UTC

can you screenshot your field in the report and then your calculated field for me to look at? 

Translate