Forum Discussion

Qrew Member

3 years ago

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

Formulas and functions

MarkShnier__You

Qrew Legend

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

Qrew Member

3 years ago

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
Qrew Legend
3 years ago
try this

var number NumDays = IF(
[Platform] = "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
  Qrew Member
  3 years ago
  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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    I guess you want this
    
    var number NumDays = IF([Platform] = "NX", 80,10);
    
    [Approval Date]-Days($NumDays)
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------