Template: Unexpected results with days_between

[ownedbycats]

(split from another thread)

Hopefully I making what I am try to do clear here.

Another Action Chains single-field edit to set enumerated #fanficstatus to "abandoned" if the selected fic is no longer available (this is marked in text #fanficerror) or has not been updated in a long time (date #fanficupdated of longer than 730 days). Three testing books are:

Book #1 (control):
#fanficstatus: In-Progress | #fanficupdated: Mar 27 2021 | #fanficerror: false
Intended result: In-Progress

Book #2 (has #fanficerror):
#fanficstatus: In-Progress | #fanficupdated: Jun 23 2020 | #fanficerror: true
Intended result: Abandoned

Book #3 (#fanficupdated more than 730 days old):
#fanficstatus: In-Progress | #fanficupdated: May 13 2013 | #fanficerror: false
Intended result: Abandoned

program:
d1 = $$#fanficupdated;
d2 = format_date(today(),'iso');
status = $#fanficstatus;

	if
		and(
			status=='In-Progress',
			days_between(d1, d2) ># 730,
			)
	then
		"Abandoned"
		elif
			and(
				status=='In-Progress',
				$#fanficerror,
				)
		then
			"Abandoned"

	else
		status
	fi

With this code, #2 returns 'abandoned' but #3 returns the existing 'in-progress'. I have confirmed this with a few other fics too. Any mistake where the idea is?

a few other things if they are of importance:

#fanficupdated always exists at the same time as #fanficstatus so I do not need to separately check for its existence.

If I turn ># 730 to 0 I get the same results. But if I turn the pointy bracket in ># 730 the other way, it returns Abandoned on all three books, so something is working, just not the way I want.

Also, if it helps I reverse-engineered my code from the one posted here.

[ownedbycats]

I figured it out. I put this code in:

d1 =  $$#fanficupdated;
d2 =  format_date(today(),'iso');

days_between(d1, d2)

and noticed the numbers were all negative. So I tried switching d1 and d2:

d1 = format_date(today(),'iso');
d2 = $$#fanficupdated;

(days_between(d1, d2) <# -730, also works, but that's a little bit silly)

And now I am getting Abandoned for both #2 and #3. That was a silly mistake.