Need SYNTAX Help with DATEDIFF

Forum|Forum|6 years ago
May 31, 2019
5 replies
1012 views

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

Workfront

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

T

TerryHy

Level 8

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

T

TerryHy

Level 8

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

B

BenettaPeAuthor

Level 9

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

B

BenettaPeAuthor

Level 9

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

T

TerryHy

Level 8

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