BAQ calculated field problem

Yahoo Archive
1
adamtuliper,
I have often had luck using the opposite logic with outer join issues as
well as date issues. Instead of comparing to a blank, try to use a not and
compare to a real expression.
For instance...
(NOT RcvDtl.ReceiptDate > 01/01/1990)
The code might not be accurate above, but maybe this will give you an idea
that helps lead to a solution.
Sometimes it also works to compare to a real date with a <...
(RcvDtl.ReceiptDate < 01/01/1990)
Might work also.
These are just off the cuff guesses first thing on a Monday, so I hope
something useful can be gained.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
adamtuliper
Sent: Sunday, January 07, 2007 5:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ calculated field problem


doh... I was almost there, it is the ="" causing the issue...

this works: (If (PoRel.DueDate<RcvDtl.ReceiptDate) Or (PoRel.DueDate
< TODAY ) then "Late" else "On-time")

however the (RcvDtl.ReceiptDate = "") from below is failing since Im
outer joining and that RcvDtl record doesn't exist, so I need a "null
check" as the ="" isn't working - any thoughts?

--- In vantage@yahoogroups.com, "adamtuliper" <amt@...> wrote:
>
> Im trying to find a reference of valid functions.
> the report builder reference for progress didnt help
> http://www.psdn.com/library/servlet/KbServlet/download/1070-102-
> 878/rbu.pdf
> as Im not surprised since its for progress report builder but had
hoped
> to have same methods available in a calcd field.
>
> I'm essentially trying an expression like the following and can't
seem
> to get today's date to compare against (and is the ="" check valid
as
> well for a null date field?):
> (If (PoRel.DueDate<RcvDtl.ReceiptDate) Or (PoRel.DueDate< Today()
And
> RcvDtl.ReceiptDate = "") then "Late" else "On-time")
>
>
> any link to a doc with valid functions in it?
>






[Non-text portions of this message have been removed]
2
Im trying to find a reference of valid functions.
the report builder reference for progress didnt help
http://www.psdn.com/library/servlet/KbServlet/download/1070-102-
878/rbu.pdf
as Im not surprised since its for progress report builder but had hoped
to have same methods available in a calcd field.

I'm essentially trying an expression like the following and can't seem
to get today's date to compare against (and is the ="" check valid as
well for a null date field?):
(If (PoRel.DueDate<RcvDtl.ReceiptDate) Or (PoRel.DueDate< Today() And
RcvDtl.ReceiptDate = "") then "Late" else "On-time")


any link to a doc with valid functions in it?
3
doh... I was almost there, it is the ="" causing the issue...

this works: (If (PoRel.DueDate<RcvDtl.ReceiptDate) Or (PoRel.DueDate
< TODAY ) then "Late" else "On-time")

however the (RcvDtl.ReceiptDate = "") from below is failing since Im
outer joining and that RcvDtl record doesn't exist, so I need a "null
check" as the ="" isn't working - any thoughts?

--- In vantage@yahoogroups.com, "adamtuliper" <amt@...> wrote:
>
> Im trying to find a reference of valid functions.
> the report builder reference for progress didnt help
> http://www.psdn.com/library/servlet/KbServlet/download/1070-102-
> 878/rbu.pdf
> as Im not surprised since its for progress report builder but had
hoped
> to have same methods available in a calcd field.
>
> I'm essentially trying an expression like the following and can't
seem
> to get today's date to compare against (and is the ="" check valid
as
> well for a null date field?):
> (If (PoRel.DueDate<RcvDtl.ReceiptDate) Or (PoRel.DueDate< Today()
And
> RcvDtl.ReceiptDate = "") then "Late" else "On-time")
>
>
> any link to a doc with valid functions in it?
>