How to calculate date difference to Todays date

[aaronnayan]

Hi Guys,

I have a date field. "[DatePurchased]

How would i calculate the difference from today's date? for example if the value of my date field [DatePurchased] was 15/01/2018, the new calculation would come up with 7

i.e:

date((date([DatePurchased],'MM/DD/YYY')-date([DatePurchased],'MM/DD/YYYY')),'DD')

I want the result in days

Thank you guys

[petter · Accepted solution]

it should be simply:

Today()-[DatePurchased]

This will return the number of days and the time difference.

If you want in whole days only:

Floor(Today())-Floor([DatePurchased])

[sunny_talwar]

May be this

Today() - DatePurchased

[shiveshsingh]

hi

Today()- DatePurchased