BAQ Week function

I know this is a late response but you can use the same syntax in a BAQ as
in the Progress language. If you are referring to the Weekday function the
syntax is

DayOfWeekNum = WEEKDAY(Date).

It will return from 1 to 7 with 1 being Sunday and 7 Saturday.

Get a copy of the Progress 4GL Reference manual (dvref.pdf). I have an
older copy from 2005 with 2410 pages. It definitely comes in handy.


Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: "Waffqle" <waffqle@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, November 17, 2011 8:38 AM
Subject: Re: [Vantage] BAQ Week function


> There isn't one built into the language. Annoyingly, I don't even see a
> quick way to pull out the day of the year. I fear you may have to add up
> all the days and then mod it yourself.
>
> On Thu, Nov 17, 2011 at 9:22 AM, michael.hutcheson@... <
> michael.hutcheson@...> wrote:
>
>> **
>>
>>
>> Hello,
>>
>> Is there a function within the BAQ calulated fields to work out the week
>> number from a date? I know that:
>>
>> Month (Table.DateField)
>>
>> Returns the month number. I tried:
>>
>> Week (Table.Datefield)
>>
>> But Vantage doesn't like this.
>>
>> Regards,
>>
>> Michael
>> Vantage 8.03.406
>>
>>
>>
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>
Hello,

Is there a function within the BAQ calulated fields to work out the week number from a date? I know that:

Month (Table.DateField)

Returns the month number. I tried:

Week (Table.Datefield)

But Vantage doesn't like this.

Regards,

Michael
Vantage 8.03.406
There isn't one built into the language. Annoyingly, I don't even see a
quick way to pull out the day of the year. I fear you may have to add up
all the days and then mod it yourself.

On Thu, Nov 17, 2011 at 9:22 AM, michael.hutcheson@... <
michael.hutcheson@...> wrote:

> **
>
>
> Hello,
>
> Is there a function within the BAQ calulated fields to work out the week
> number from a date? I know that:
>
> Month (Table.DateField)
>
> Returns the month number. I tried:
>
> Week (Table.Datefield)
>
> But Vantage doesn't like this.
>
> Regards,
>
> Michael
> Vantage 8.03.406
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


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

Forgot to say I'm running Progress as well.

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> There isn't one built into the language. Annoyingly, I don't even see a
> quick way to pull out the day of the year. I fear you may have to add up
> all the days and then mod it yourself.
>
> On Thu, Nov 17, 2011 at 9:22 AM, michael.hutcheson@... <
> michael.hutcheson@...> wrote:
>
> > **
> >
> >
> > Hello,
> >
> > Is there a function within the BAQ calulated fields to work out the week
> > number from a date? I know that:
> >
> > Month (Table.DateField)
> >
> > Returns the month number. I tried:
> >
> > Week (Table.Datefield)
> >
> > But Vantage doesn't like this.
> >
> > Regards,
> >
> > Michael
> > Vantage 8.03.406
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
Example #17 How do you age against todays date?
Expression: Integer(Today) - Integer(OrderHed.RequestDate)

I would think something like above could help...

Maybe Integer((Integer(Table.DateField) - number of odd days at beginning of year) / 7) = weekno?

Something similar might work, but not tested...


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of michael.hutcheson@...
Sent: Thursday, November 17, 2011 8:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Week function



ah shot.

Forgot to say I'm running Progress as well.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Waffqle <waffqle@...<mailto:waffqle@...>> wrote:
>
> There isn't one built into the language. Annoyingly, I don't even see a
> quick way to pull out the day of the year. I fear you may have to add up
> all the days and then mod it yourself.
>
> On Thu, Nov 17, 2011 at 9:22 AM, michael.hutcheson@<mailto:michael.hutcheson@>... <
> michael.hutcheson@<mailto:michael.hutcheson@>...> wrote:
>
> > **
> >
> >
> > Hello,
> >
> > Is there a function within the BAQ calulated fields to work out the week
> > number from a date? I know that:
> >
> > Month (Table.DateField)
> >
> > Returns the month number. I tried:
> >
> > Week (Table.Datefield)
> >
> > But Vantage doesn't like this.
> >
> > Regards,
> >
> > Michael
> > Vantage 8.03.406
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*<mailto:waffqle@...*>
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
Using the Production Calendar there is a week number setup that is possible there.

I have not done this though.

I suppose if one defined the weeks in the Prodcution Calendar then that data would be availble to a BAQ.

It still would be nice to have a week function in the BAQ I agree.

Brad Boes
Metalworks


--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> Example #17 How do you age against todays date?
> Expression: Integer(Today) - Integer(OrderHed.RequestDate)
>
> I would think something like above could help...
>
> Maybe Integer((Integer(Table.DateField) - number of odd days at beginning of year) / 7) = weekno?
>
> Something similar might work, but not tested...
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of michael.hutcheson@...
> Sent: Thursday, November 17, 2011 8:46 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Week function
>
>
>
> ah shot.
>
> Forgot to say I'm running Progress as well.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Waffqle <waffqle@<mailto:waffqle@>> wrote:
> >
> > There isn't one built into the language. Annoyingly, I don't even see a
> > quick way to pull out the day of the year. I fear you may have to add up
> > all the days and then mod it yourself.
> >
> > On Thu, Nov 17, 2011 at 9:22 AM, michael.hutcheson@<mailto:michael.hutcheson@>... <
> > michael.hutcheson@<mailto:michael.hutcheson@>...> wrote:
> >
> > > **
> > >
> > >
> > > Hello,
> > >
> > > Is there a function within the BAQ calulated fields to work out the week
> > > number from a date? I know that:
> > >
> > > Month (Table.DateField)
> > >
> > > Returns the month number. I tried:
> > >
> > > Week (Table.Datefield)
> > >
> > > But Vantage doesn't like this.
> > >
> > > Regards,
> > >
> > > Michael
> > > Vantage 8.03.406
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@*<mailto:waffqle@*>
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>