Expand my Community achievements bar.

Come join us for our Coffee Break next week on top takeaways from Adobe Summit!

Need SYNTAX Help with DATEDIFF

Avatar

Level 10
I have 4 columns on an issue report entryDate resolveProjectentryDate I have these two columns showing dates, with no problem. I am trying to create a 3rd column to show their difference.But my syntax is wrong - as I am getting nothing. DATEDIFF(date1, date2) DATEDIFF(entryDate, resolveProjectentryDate) I want the fourth column to be the date difference between resolveProjectentryDate and $$Today. DATEDIFF (resolveProjectentryDate, $$TODAY) Either I have the syntax incorrect or I am missing information. Thanks for you help Benetta Perry APS
5 Replies

Avatar

Level 7
Hi Benetta, for your 3rd column, try this as you valueexpression: valueexpression=ROUND(DATEDIFF({entryDate},{resolveProject}.{entryDate})) Terry Hynd EBSCO Information Services

Avatar

Level 7
And for your 4th column, try this as your value expression: valueexpression=ROUND(DATEDIFF($$TODAY,{resolveProject}.{entryDate})) Terry Hynd EBSCO Information Services

Avatar

Level 10
Terry, P E R F E C T. I do this same syntax for $$TODAY? to get the days between resolveProjectentryDate and today? THANKS A MILLION.... Benetta Perry APS

Avatar

Level 10
Terry, I'm up and running. MANAGEMENT is Happy. THANKS a Million. Benetta Perry APS

Avatar

Level 7
YAY! Glad I could help out. Terry Hynd EBSCO Information Services