Forum Discussion
Try this as a formula numeric field called [Project Duration Days]
var date EndDate = IF(not IsNull([Date Completed]),[Date Completed],Today());
ToDays($EndDate - ToDate([Date Created]))
The built in field for [Date Created] is actually a date/time field type so that is why it needs to be converted to a date with the ToDate function.
var date EndDate = IF(not IsNull([Date Completed]),[Date Completed],Today());
ToDays($EndDate - ToDate([Date Created]))
The built in field for [Date Created] is actually a date/time field type so that is why it needs to be converted to a date with the ToDate function.
I suggest that you build you own link.
Here is an example.
I always do them this way as that way the syntax is always correct the first time.
var text Words = [Account Name];
var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
"<a href=" & $URL & ">" & $Words & "</a>
Here is an example.
I always do them this way as that way the syntax is always correct the first time.
var text Words = [Account Name];
var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
"<a href=" & $URL & ">" & $Words & "</a>