Date Formulas.. need help understanded please

[hpang]

Im trying to enter a forumla that shows the difference between the date that a task was completed and the current date. I know there is a function datediff( interval, date1, date2).

I cant seem to make thie function work. I do not know what to enter in the interval field. I just want to show the number of days till the scheduled end date compared to the current date. I.E. today is the 29th, task is scheduled to end on the 31st, the field should show 2 days.

datediff( ???, date(), {Baseline Finish]) what goes i nthe ???? and does this seem right. Thanks.

 

[PDQBach]

P2002

Assuming you are using a number field,
Datediff("d", [Start], Now() )

"d" means days
"w" means weeks
"m" means months

Please don't ask to have non-working days (like weekend days) removed from the calculation.

 

[hpang]

THANKS!!!!

Exactly what I needed. I tried everything I could thinking of including entering integers to spelling out "days" "weeks" etc... didnt think of "d" and "w"