Date01 needs nonNull (valid date) values in the queried records are it will fail.
Other than that, no problems using this technique from 305g thru 405a.
Haven't had to rewrite any but I'm sure that day will eventually come - probably when we bounce to the long awaited (for us as it is supposed to resolve a critical SCR) - 408. {;o
Other than that, no problems using this technique from 305g thru 405a.
Haven't had to rewrite any but I'm sure that day will eventually come - probably when we bounce to the long awaited (for us as it is supposed to resolve a critical SCR) - 408. {;o
--- On Wed, 4/22/09, Daniel Laidig <daniellaidig@...> wrote:
From: Daniel Laidig <daniellaidig@...>
Subject: RE: [Vantage] BAQ Formula date
To: vantage@yahoogroups.com
Date: Wednesday, April 22, 2009, 1:17 PM
I was actually just looking at this same thing today on Vantage 8.03.403 and
found that the date feature in our BAQ didn't work. It always returned no
results. I was using Orderdtl.Date01 <= Today-0.
Daniel
<mailto:daniellaidig@ laidig.com> daniellaidig@ laidig.com
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Robert Brown
Sent: Wednesday, April 22, 2009 1:01 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BAQ Formula date
You only want to look at ShipHead records with ShipDate one or MORE years
old?
That should work (if they exist)... Make sure you are not filtering out
Closed corresponding orders.
--- On Wed, 4/22/09, vantageuser13 <vantageuser13@ yahoo.com
<mailto:vantageuser 13%40yahoo. com> > wrote:
From: vantageuser13 <vantageuser13@ yahoo.com
<mailto:vantageuser 13%40yahoo. com> >
Subject: [Vantage] BAQ Formula date
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Date: Wednesday, April 22, 2009, 11:26 AM
In my baq, I will need to add this formula for the shiphead.shipdate <=
today() - 365. My formula is today - 365 days. But If I entered this
exacthly formula, doesn't works. What the good formula for entered in the
BAQ ?
Thanks
Vantage 8.03.305K
[Non-text portions of this message have been removed]