Skip to main content
Question

Formula Help

  • January 25, 2022
  • 0 replies
  • 39 views
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 each order takes, any help would be great.

Thanks,
Derek

------------------------------
Derek Pipal
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • January 25, 2022
np,
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement