I have a created date field in my app which is a datetime data type to record when was the customer created. I want to calculate the “Lead Age” in days, which should update automatically. Please help me with the formula for the same.
Create a Virtual Column named LeadAge with the expression:
HOUR(NOW() - [YourDateColumn]) / 24