calculating datediff for a report | Community
Skip to main content
G
GayatriPatelCSA
New Participant
August 26, 2025
Question

calculating datediff for a report

  • August 26, 2025
  • 1 reply
  • 421 views

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

 

1 reply

KellieGardner
KellieGardner
New Participant
August 26, 2025

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})

 

G
GayatriPatelCSAAuthor
New Participant
August 26, 2025

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.

KellieGardner
KellieGardner
New Participant
August 26, 2025

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

Terms & ConditionsAccessibility statement

Loading footer...