1 of 1 people found this helpful
To find the difference between 2 dates in Days, use the DATEDIFF() function. e.g.: DATEDIFF('day', Date_Column_1, Date_Column_2)
To find the difference between Today and a date, use this: DATEDIFF('day', TODAY(), Date_Column)
Let me know if you need anything else. Thanks.
Thanks Sagar. The solution worked for me after I converted the value of date from db to DATE format using DATE function and following the steps you mentioned.