Calculate the number of days between Today and Date Modified
I need a formula to calculate from todays date to the time a project was last modified. Any help would be appreciated!!
Forum Discussion
I'm trying to get the difference between todays date and the expected start date of a project but if the project has been started already, I want the value to be NA. I have a text field and it's not letting me put the "-", if I do a numeric, it won't let me do the value NA
If(
not IsNull([Started]),"N/A",
ToText(([Start])-(Now())
)
)
If(
not IsNull([Started]),"N/A",
ToText(([Start])-(Now())
)
)
- Try this
If(
not IsNull([Started]),"N/A",
ToText(ToDays(Today() - [Start]))) - I'm getting an error, "-" can't be applied to dates and times
- Can you tell me what type of field [Start] is?
- It is a date/time field, same thing with Started.
- Ok, try this
If(
not IsNull([Started]),"N/A",
ToText(ToDays(Today() - ToDate([Start])))) - That worked! Thank you! One last question, I want the value to be negative to indicate that the task has been done after the expected start date. I tried to just reverse the 2 functions but now it doesn't work.
- Sure, I made the assumption that you wanted a positive number
If(
not IsNull([Started]),"N/A",
ToText(ToDays(ToDate([Start]) - Today()))) - Thank you so much!!!!!
- Ultimate last question on this one. Is there a way that I can have one decimal place on the number value on this field?
- If(
not IsNull([Started]),"N/A",
ToText(ToDays(ToDate([Start]) - Today())))
& ".0Hello,
Is there a way for a day counter to reflect how long since a field has been altered?I have a status field for projects and I want it to change to count days since it's been changed each time. It doesn't need to log it anywhere, just something to look at and see if a project has been in a position for too long.
The field I'm referencing is called Status.
------------------------------
Anthony Wong
------------------------------- MarkShnier__You
Qrew Legend
This sounds like an unrelated question to the thread. Can you post a new question?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
