Formula Help
Hello, I have two date fields called 1) Entry Date 2) Ship Date. I want to create a numeric formula field that tells me how many days it took from the Entry Date to the Ship Date to track how long...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
Try this as a formula numeric field type.
var date ShipDateOrToday = IF(IsNull([Ship Date]), Today(), [ShipDate]);
Todays($ShipDateOrToday - [Entry Date])
// the formula above will have a running count of the days from the Entry date
// until today up until the Ship date is populated.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Try this as a formula numeric field type.
var date ShipDateOrToday = IF(IsNull([Ship Date]), Today(), [ShipDate]);
Todays($ShipDateOrToday - [Entry Date])
// the formula above will have a running count of the days from the Entry date
// until today up until the Ship date is populated.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Perfect thank you Mark.
------------------------------
Derek Pipal
------------------------------
------------------------------
Derek Pipal
------------------------------