Pulling my hair out again...
I need to calculate the difference between two dates in days. I'm doing this:
<cfset d = DateDiff("d", Dateformat( active_apps.app_base_coupon_start, "dd.mm.yyyy"), Dateformat( variables.useDate, "dd.mm.yyyy") )>
variables.useDate = today =
I dumped both values, they are OK. However the
-168 when I was looking for (4 days in July, 31 in August, 30 in September, 2 in October) 67 days.
Can someone prevent me from losing my remaining hair and tell me what I'm doing wrong here or if there is an easier way to get the difference in days?
Ok, it also works like this:
<cfif DateAdd("d", active_apps.app_grace_time, Dateformat( active_apps.app_base_coupon_start, "dd.mm.yyyy") ) GT now()> <cfdump output="e:\s\page\t\dump.txt" label="catch" var="YUP"> <cfelse> <cfdump output="e:\s\page\t\dump.txt" label="catch" var="NOPE"> </cfif>
but I would still like to know, why
dateDiff is returning strange values.