Elapsed days calculation in Project Web Access Issues

[John Borton]

I am trying to add a column that would show the number of days since an issue
was submitted. I tried the formula =DATEDIF(TODAY,[Date Submitted],"D")
where Date Submitted is a date column that I had previously added. I get a
syntax error because the TODAY function cannot be used in a calculation. Any
ideas of how I can do this.

 

[DavidC]

Hi John,

Try this in a number field, DateDiff("d",[Date Submitted],Now())

You will get the number of days between today and the date submitted.

Hope this helps

Regards

DavidC

 

[John Borton]

Hi David,

I copied that into the formula and got the following error:

The formula contains a syntax error or is not supported.

I tried putting an = in front of DateDiff and got the same error. Am I
doing something wrong?
John

Hi John,

Try this in a number field, DateDiff("d",[Date Submitted],Now())

You will get the number of days between today and the date submitted.

Hope this helps

Regards

DavidC

I am trying to add a column that would show the number of days since an issue
was submitted. I tried the formula =DATEDIF(TODAY,[Date Submitted],"D")
where Date Submitted is a date column that I had previously added. I get a
syntax error because the TODAY function cannot be used in a calculation. Any
ideas of how I can do this.