Welcome, Guest. Please Login
Tinderbox
  News:
IMPORTANT MESSAGE! This forum has now been replaced by a new forum at http://forum.eastgate.com and no further posting or member registration is allowed. The forum is still accessible via read-only access for reference purposes. If you wish to discuss content here, please use the new forum. N.B. - posting in the new forum requires a fresh registration in the new forum (sorry - member data can't be ported).
  HomeHelpSearchLogin  
 
Pages: 1
Send Topic Print
Trouble with Agent Query Since Upgrade (Read 3751 times)
Hugh Akston
Full Member
*
Offline



Posts: 7

Trouble with Agent Query Since Upgrade
Mar 06th, 2009, 10:01pm
 
Hi, Tinderbox newbie here.....I'm having problems with an agent since the 4.6 upgrade.  The problem seems to be with the "&" operator.

Query:
#inside(Journal Entries)&Date>12/31/2008&Date<2/1/2009

This agent is supposed to show me all journal entries for January 2009.  I've tried every variation that I can think of.   Any advice?

Thanks!

Back to top
 
 
  IP Logged
Loryn
Full Member
*
Offline



Posts: 97

Re: Trouble with Agent Query Since Upgrade
Reply #1 - Mar 7th, 2009, 3:52am
 
The release notes (Actions: date() or quotation marks required for dates) say:

Dates that use '/" as a delimiter (4/30/2008) must be quoted or used inside a date() expression.
Formerly, some queries worked correctly without quoting the date:
     Date<4/15/2008            <-- wrong
but this is now interpreted as an arithmetic expression. The correct form is now
     $Date<"4/15/2008"
or, better,
     $Date<date("4/15/2008")
Back to top
 
 
  IP Logged
Hugh Akston
Full Member
*
Offline



Posts: 7

Re: Trouble with Agent Query Since Upgrade
Reply #2 - Mar 7th, 2009, 9:27am
 
Thanks Loryn!   I knew it had to be something simple.   Smiley
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print