How to calculate days for past and future days?

[DataOrg]

Hello,

I want to calculate the days in difference like below like future days should be in positive and past days should be negative

i tried eval diff=(now()-_time) and did strftime(diff,"%D") but here all are in positive days. i want the past days in negative

Date	Difference in Days
04-02-2022	-5
05-02-2022	-4
06-02-2022	-3
07-02-2022	-2
08-02-2022	-1
09-02-2022	0	Today Date
10-02-2022	1
11-02-2022	2
12-02-2022	3
13-02-2022	4

[ITWhisperer · Accepted solution]

| eval diff=floor((_time-now())/(60*60*24))