This question about Using an extension: Answered

How can I compare dates within a format string in dbquery?

How can I compare dates within a format string in dbquery?

format="| $formfield(due) | $percntIF{\"d2n('$formfield(due)') < d2n('29 Mar 2024')\" then=\"A\"}$percnt | "

I try to compare two time formats, whereas one is stored in the formfield named ""due". Alas it returns always the result A regardless, if the value for due is earlier or later than 29 Mar 2024. It seems that d2n('$formfield(due) is always zero. due is in the format 22 Apr 2013.

Any idea? Thanks in advance!

-- ThomasSchmidt - 22 Apr 2013

Does
format="| $formfield(due) | $percntIF{\"d2n('$topic'/due) < d2n('22 Apr 2013')\" then=\"A\" else=\"B\"}$percnt | " 

make a difference? This type of d2n construct seems to be used quite often in applications that use dates on Foswiki.org

And there are some d2n related examples at WriteAQueryCookbook you could try.

-- FranzJosefGigler - 22 Apr 2013

Thx, but no. For me it seems that d2n simply doesn't allow variables. Whatever variable I insert in d2n there is no result.

-- ThomasSchmidt - 23 Apr 2013

ok, just found out that you don't have to use d2n in the first place. That means it works just using the variable instead of d2n

-- ThomasSchmidt - 23 Apr 2013

I believe this should work:

format="| $formfield(due) | $percntIF{\"$IF($TIME($formfield(due)) < $TIME(%DATE%), A, B)\"}$percnt | " 

-- LynnwoodBrown - 24 Apr 2013

No sorry nothing worlks within DBQUERY. Perhaps there is a bug in that plugin

$percntIF{\"$percntCALC{$IF($TIME($formfield(due)) < $TIME(25 Apr 2013), A, B)\"}$percnt}$percnt

doesnt work either

-- ThomasSchmidt - 25 Apr 2013

DBQUERY will convert $d2n(dateformfiled) to epoch seconds. So the example should be something along the lines of:

%DBQUERY{
   "query"
  format="| $formfield(due) | $percntIF{\"$d2n(due) < $d2n('22 Apr 2013')\" then=\"A\" else=\"B\"}$percnt | " 
}%

-- MichaelDaum - 27 May 2013

Thanks!

-- ThomasSchmidt - 28 May 2013
 

QuestionForm edit

Subject Using an extension
Extension DBCachePlugin
Version Foswiki 1.1.8
Status Answered
Related Topics
Topic revision: r7 - 28 May 2013, ThomasSchmidt
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy