Formula Help

Question

Hello,I have two date fields called 1) Entry Date 2) Ship Date.&nbsp; 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------------------------------

markshnier__you · Answer

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
------------------------------

derekpipal1 · Answer

Perfect thank you Mark.------------------------------Derek Pipal------------------------------

derekpipal1 · Answer

I currently have this formula in a date field

[Launch Date]-Days(Case([Distribution Type],"Digital Only",28,"Digital and Retail",62))

But I also need to have a formula for when the "Platform" field is =NX to change the "Approval Date" field 80 days before the "Launch Date" field. Any idea how I would write that up?

Thanks,

Derek

------------------------------
Derek Pipal
------------------------------

markshnier__you · Answer

try thisvar number NumDays = IF([Platform]&nbsp; = "NX", 80,[Distribution Type]= "Digital Only", 28,[Distribution Type]= "Digital and Retail",62));[Launch Date]-Days($NumDays)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

derekpipal1 · Answer

Great thank you worked.I have one last formula question.My current formula is below[Approval Date]-Days(10)This works fine for all the items in my Platform field except "NX". I want "NX" to show 80 days here and leave the rest of the items in the Platform field at 10 days. Let me know if you can help here as well and thanks again for all your help.------------------------------Derek Pipal------------------------------

Forum Discussion

Formula Help

7 Replies