Custom Functions into BAQ designer

Yahoo Archive
1
Download the free pdf of the OpenEdge Development Progress 4GL Handbook. Many of the simpler functions can be used in BAQ formula fields.


From: Waffqle <waffqle@...>
To: vantage@yahoogroups.com
Sent: Friday, August 26, 2011 2:14 PM
Subject: Re: [Vantage] Custom Functions into BAQ designer

I think calculated fields are as good as you're going to get in that arena.
But they're fairly versatile once you get the hang of em.

On Fri, Aug 26, 2011 at 12:09 PM, Nancy <nhoyt111@...> wrote:

> **
>
>
> Good Afternoon,
>
> I am wondering if there is any way include a custom function (vba or .p
> file?) for availablity to use in BAQ formula.
>
> I am trying to get a handle on ISOWeeknumber, akin to Excel vba:
>
> Public Function IsoWeekNumber(InDate As Date) As Long
> IsoWeekNumber = DatePart("ww", InDate, vbMonday, vbFirstFourDays)
> End Function
>
> It's amazing how something so easy in Excel is so hard in Epicor,
> especially in the BAQ designer!
>
> Thanks,
> Nancy
>
>Â
>



--
*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/.%c2%a0
(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



[Non-text portions of this message have been removed]
2
Good Afternoon,

I am wondering if there is any way include a custom function (vba or .p file?) for availablity to use in BAQ formula.

I am trying to get a handle on ISOWeeknumber, akin to Excel vba:

Public Function IsoWeekNumber(InDate As Date) As Long
IsoWeekNumber = DatePart("ww", InDate, vbMonday, vbFirstFourDays)
End Function

It's amazing how something so easy in Excel is so hard in Epicor, especially in the BAQ designer!

Thanks,
Nancy
3
I think calculated fields are as good as you're going to get in that arena.
But they're fairly versatile once you get the hang of em.

On Fri, Aug 26, 2011 at 12:09 PM, Nancy <nhoyt111@...> wrote:

> **
>
>
> Good Afternoon,
>
> I am wondering if there is any way include a custom function (vba or .p
> file?) for availablity to use in BAQ formula.
>
> I am trying to get a handle on ISOWeeknumber, akin to Excel vba:
>
> Public Function IsoWeekNumber(InDate As Date) As Long
> IsoWeekNumber = DatePart("ww", InDate, vbMonday, vbFirstFourDays)
> End Function
>
> It's amazing how something so easy in Excel is so hard in Epicor,
> especially in the BAQ designer!
>
> Thanks,
> Nancy
>
>
>



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

*

*


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