ShowAll Questionssorted byDate Posted
Abhilash 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
Jetha
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

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

I

Jetha
if( (Today() -  EffectiveDate) >7, true, false)
Abhilash Mishra 13
so the difference between dates be an integer value...
Thanks
Hope it solves my problem.
Jetha
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