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.
Another question if I may.
In a message from quickbase, I want to put a link to the original message in the email.
I know that the link is created using: %recLink%
However, is it possible to put this in a href tag?
<a href="%recLink%">REPLY to this message</a>
It is not displaying properly in my test
In a message from quickbase, I want to put a link to the original message in the email.
I know that the link is created using: %recLink%
However, is it possible to put this in a href tag?
<a href="%recLink%">REPLY to this message</a>
It is not displaying properly in my test