Need SYNTAX Help with DATEDIFF

[BenettaPe]

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

[TerryHy]

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

[TerryHy]

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

[BenettaPe]

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

[BenettaPe]

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

[TerryHy]

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