How can you subtract a date field from the current day's date?
For example. Date field is 1/1/14. Todays date is 1/15/14. Answer = 15 days.
Forum Discussion
You could set up an "If" statement if you have a "Project Start Date" but I think the field would have to be a formula text field:
If(
not IsNull([Project Start Date]),"N/A",
ToText(ToDays(Today() - ToDate([Assigned Date]))
)
)
unfortunately with this is if you sort by this field, it will sort alphabetically and not numerically. For example, if you had the data: 1, 2, 3, 4, 12, 22, 42, N/A
it would sort to this:
1
12
2
22
3
4
42
N/A
If(
not IsNull([Project Start Date]),"N/A",
ToText(ToDays(Today() - ToDate([Assigned Date]))
)
)
unfortunately with this is if you sort by this field, it will sort alphabetically and not numerically. For example, if you had the data: 1, 2, 3, 4, 12, 22, 42, N/A
it would sort to this:
1
12
2
22
3
4
42
N/A
^^^^ What he said.