6.1 BAQ - Filtering for Blank Date

Yahoo Archive
1
Thanks for the suggestions, the ? worked!

Thank you





Stuart Noble
Thompson Meat Machinery
Ph: + 61 7 3803 6643

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Podlin, Michael
Sent: Thursday, 7 June 2007 10:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.1 BAQ - Filtering for Blank Date



Use JobHead.TravelerLastPrinted = ? no-lock

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Stuart Noble
Sent: Wednesday, June 06, 2007 8:40 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 6.1 BAQ - Filtering for Blank Date

Hi there,

I am trying to filter BAQ results to only show those job Travelers with
a blank printed date, as these often get missed, especially with the
constant crashing while printing. However, when I try to use a command
such as:

and JobHead.TravelerLastPrinted = '' no-lock

I get an error message saying data types are incompatible. In Crystal, I
am sure if I used the to-text command, the blank would convert to a
terxt blank, and this would work fine. Is there an equivalent in
progress, or has anyone worked out the way to filter on unfilled date
fields such as this?

Thanks

Stuart Noble
Thompson Meat Machinery




[Non-text portions of this message have been removed]
2
Hi there,

I am trying to filter BAQ results to only show those job Travelers with
a blank printed date, as these often get missed, especially with the
constant crashing while printing. However, when I try to use a command
such as:



and JobHead.TravelerLastPrinted = '' no-lock



I get an error message saying data types are incompatible. In Crystal, I
am sure if I used the to-text command, the blank would convert to a
terxt blank, and this would work fine. Is there an equivalent in
progress, or has anyone worked out the way to filter on unfilled date
fields such as this?



Thanks



Stuart Noble
Thompson Meat Machinery

Ph: + 61 7 3803 6643





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

and JobHead.TravelerLastPrinted < 01/01/1991 no-lock



[Non-text portions of this message have been removed]
4
Use JobHead.TravelerLastPrinted = ? no-lock

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Stuart Noble
Sent: Wednesday, June 06, 2007 8:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.1 BAQ - Filtering for Blank Date



Hi there,

I am trying to filter BAQ results to only show those job Travelers with
a blank printed date, as these often get missed, especially with the
constant crashing while printing. However, when I try to use a command
such as:

and JobHead.TravelerLastPrinted = '' no-lock

I get an error message saying data types are incompatible. In Crystal, I
am sure if I used the to-text command, the blank would convert to a
terxt blank, and this would work fine. Is there an equivalent in
progress, or has anyone worked out the way to filter on unfilled date
fields such as this?

Thanks

Stuart Noble
Thompson Meat Machinery

Ph: + 61 7 3803 6643

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







[Non-text portions of this message have been removed]
5
I don't know if this has been fixed but it was the case the the last
printed date used to get populate on print preview also.



--- In vantage@yahoogroups.com, "Stuart Noble" <stuart@...> wrote:
>
> Hi there,
>
> I am trying to filter BAQ results to only show those job Travelers
with
> a blank printed date, as these often get missed, especially with the
> constant crashing while printing. However, when I try to use a
command
> such as:
>
>
>
> and JobHead.TravelerLastPrinted = '' no-lock
>
>
>
> I get an error message saying data types are incompatible. In
Crystal, I
> am sure if I used the to-text command, the blank would convert to a
> terxt blank, and this would work fine. Is there an equivalent in
> progress, or has anyone worked out the way to filter on unfilled
date
> fields such as this?
>
>
>
> Thanks
>
>
>
> Stuart Noble
> Thompson Meat Machinery
>
> Ph: + 61 7 3803 6643
>
>
>
>
>
> [Non-text portions of this message have been removed]
>