BAQ to the wall

Yahoo Archive
1
> I think it's a little simpler than that. First what version?
> 6.1 is a little more limited and what I am more familiar with. If I am not
> mistaken, you are looking for (forgive the sudo code):
> =Month(fiscal period start + days) and =Year(fiscal period start + days).
> Days being the number of days to get you safely into the last month of your
> fiscal period.
> Is this in the direction you were looking for?

Not quite, but in retrospect, I think I'm over-reaching the technology...

Previously, there was a report called Daily Sales Orders by Product Group. It
would give a daily total of orders entered for that day by product group. I
was thinking that this would be a cool Dashboard but I was going to give them
the view to see it by fiscal year, month, or day. This report is a no-brainer
in Crystal but I thought that a BAQ and Dashboard would be cool but maybe this
is more of a VBI kind of thing. The BAQ that searches for a whole year's worth
of orders might take more time than one would want to wait for...

Thanks,

Mark W.
2
I'm trying to create a BAQ which calculates the fiscal period. (11/2006 is
01-2007, 12/2006 is 02-2007, etc...)

I'm trying to use a Calc field in the Display tab but it keeps complaining
about a syntax error. I have tried using ADD-INTERVAL but that's Progress 4G/L
only. I tried using ADD_MONTHS which works in ODBC but that chokes too. Is
there a way I can add two months to a date and use it in a BAQ?

Thanks,

Mark W.
3
Mark,
I think it's a little simpler than that. First what version?
6.1 is a little more limited and what I am more familiar with. If I am not
mistaken, you are looking for (forgive the sudo code):
=Month(fiscal period start + days) and =Year(fiscal period start + days).
Days being the number of days to get you safely into the last month of your
fiscal period.
Is this in the direction you were looking for?
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Mark Wonsil
Sent: Friday, December 08, 2006 1:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ to the wall...


I'm trying to create a BAQ which calculates the fiscal period. (11/2006 is
01-2007, 12/2006 is 02-2007, etc...)

I'm trying to use a Calc field in the Display tab but it keeps complaining
about a syntax error. I have tried using ADD-INTERVAL but that's Progress
4G/L
only. I tried using ADD_MONTHS which works in ODBC but that chokes too. Is
there a way I can add two months to a date and use it in a BAQ?

Thanks,

Mark W.






[Non-text portions of this message have been removed]