Create Day Count based on Field Going from Null to Populated

Question

Not sure if it is possible, but can you create a day count from the time a field gets populated from Null to one with values and then end the count when another field status changes to Shipped? Below is what I have for data for Order Number, Trip and Status. Green would be the desired result and yellow would just be the explanation on how the green was calculated using system dates not available currently. Yellow is not needed but used below to help illustrated what I am trying to do for the Day calc

Qiu · Answer

@BobbyQ 
I am also a bit confused as @alexnajm .
Maybe you can simply provide a sample input and desired output file?

alexnajm · Answer

Right but there needs to be a mechanism then to store a “start date” when the “not shipped” record first shows. If you are saying that can just be when it first shows, then yes a DateTimeToday function could work. You’d then have that workflow run daily and basically keep the start date value if it already has one, but use DateTimeToday for those that don’t!

so yes overall very possible, but I think you’ll have to confirm the mechanism to get the first date to calculate against the date when the record changed to shipped

BobbyQ · Answer

No I dont have any dates since I believe that could just be calculated using datediff between the two dates. It would have to be done with what I provided above. I was hoping you could utilize a Datetimenow() trigger once the Trip field changed from Null.