BAQ Constants Blank Title 70822

Yahoo Archive
1
I answered my own question.
You would choose the date field you are going against
Then choose >= and IsConst checked
Check the Use From Today's value checkbox
Then in the From Today Value enter -365

What looked wierd is when you click FINISH and see the query in the
Phrase Builder.

Here is what it looks like:
for each LaborDtl where ( LaborDtl.LaborType <> 'I' AND
LaborDtl.PayrollDate >= TODAY + -367) no-lock , each Resource where
(LaborDtl.Company = Resource.Company and LaborDtl.ResourceID =
Resource.ResourceID) no-lock .

The TODAY + -367 (last year being leap year and all) looked like it
would go forward and then back...but it works.

Patty Buechler


--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> I know how to set constants in a BAQ. However I don't know how to
set
> the value to be year -1 (or 365 back from today's date).
>
> This BAQ is used on an Executive Query so when the Process Set
runs, it
> will always go back 365 from todays date.
>
> Any suggestions?
> TIA
> Patty Buechler
>
2
I know how to set constants in a BAQ. However I don't know how to set
the value to be year -1 (or 365 back from today's date).

This BAQ is used on an Executive Query so when the Process Set runs, it
will always go back 365 from todays date.

Any suggestions?
TIA
Patty Buechler