+ Start a Discussion
Abhilash Mishra 13Abhilash Mishra 13 

Formula to Calculate Order age

I have need to calculate order age. how can I write a formulate in formula field.
(My order age will start with the order start date. and end on Either current date or order End Date)

Need Help 
Abhilash Mishra
Best Answer chosen by Abhilash Mishra 13
JethaJetha
Difference  between two dates would be in days and off course in integer.

Don't forget to mark it best answer, if this resolves your issue.

Thanks,
jetha
 

All Answers

JethaJetha
Today() -  EffectiveDate 
Abhilash Mishra 13Abhilash Mishra 13
what will the proper formula if I had to check where order age is greater than  7 & OR not

I
 
JethaJetha
if( (Today() -  EffectiveDate) >7, true, false)
Abhilash Mishra 13Abhilash Mishra 13
so the difference between dates be an integer value... 
Thanks
Hope it solves my problem.
JethaJetha
Difference  between two dates would be in days and off course in integer.

Don't forget to mark it best answer, if this resolves your issue.

Thanks,
jetha
 
This was selected as the best answer