BAQ Calculated Field Error

Yahoo Archive
1
Good catch

Solved with

String(Year(JobHead.DueDate)) + "-" + String(Month(JobHead.DueDate))

Its stupid that it passes Syntax Check.

Thanks!!!


*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 3:24 PM, bw2868bond <bwalker@...>wrote:

>
>
> Don't the YEAR and MONTH functions return numbers?
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Man I am needy today ;-)
> >
> > Eitherway, I have a calculated field on a BAQ I am writing as such
> >
> > Year(JobHead.DueDate) + "-" + Month(JobHead.DueDate)
> >
> > It passes Syntax Check but when I try to use the BAQ I get this error
> >
> > Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
> > Please contact your System Administrator.
> >
> > Can someone test it and see if they get the same thing? Am I doing
> something
> > wrong?
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
2
Man I am needy today ;-)

Eitherway, I have a calculated field on a BAQ I am writing as such

Year(JobHead.DueDate) + "-" + Month(JobHead.DueDate)

It passes Syntax Check but when I try to use the BAQ I get this error

Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
Please contact your System Administrator.

Can someone test it and see if they get the same thing? Am I doing something
wrong?

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*


[Non-text portions of this message have been removed]
3
Don't the YEAR and MONTH functions return numbers?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Man I am needy today ;-)
>
> Eitherway, I have a calculated field on a BAQ I am writing as such
>
> Year(JobHead.DueDate) + "-" + Month(JobHead.DueDate)
>
> It passes Syntax Check but when I try to use the BAQ I get this error
>
> Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
> Please contact your System Administrator.
>
> Can someone test it and see if they get the same thing? Am I doing something
> wrong?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> [Non-text portions of this message have been removed]
>