Vantage 8.03 BAQ - Null Date Field

In Progress, the null value for a date field is a ? mark. Try not equal to
?.



Carl



Carl D. Peterson, CPIM

Nexus Software, Inc.

Plymouth, Michigan 48170

1-734-812-9532 - Mobile

1-734-453-3101 - Office

1-734-455-9550 - Fax

cpeterson@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
laidig.systems
Sent: Sunday, September 16, 2007 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 BAQ - Null Date Field



Has anyone had any luck using BAQ query's and null dates. I want to
display all records where Date01 doesn't have a date yet, but i cannot
seem to accomplish this with BAQs because the BAQ doesn't give me an
option to compare the date to "null" I have tried to set the Date01
to another date field that i know is null but that doesn't work
either. Any suggestions?





[Non-text portions of this message have been removed]
Has anyone had any luck using BAQ query's and null dates. I want to
display all records where Date01 doesn't have a date yet, but i cannot
seem to accomplish this with BAQs because the BAQ doesn't give me an
option to compare the date to "null" I have tried to set the Date01
to another date field that i know is null but that doesn't work
either. Any suggestions?
A quick trick is to use a formula to see if the field is greater than 0 and
use and if then statement to set the field to 1 or 0 base on the statement.
Example: If Date01 > 0 then 1 else 0 then use this field for your BAQ check.



Steve



-----Original Message-----
From: laidig.systems [mailto:laidig.systems@...]
Sent: September 16, 2007 11:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 BAQ - Null Date Field



Has anyone had any luck using BAQ query's and null dates. I want to
display all records where Date01 doesn't have a date yet, but i cannot
seem to accomplish this with BAQs because the BAQ doesn't give me an
option to compare the date to "null" I have tried to set the Date01
to another date field that i know is null but that doesn't work
either. Any suggestions?





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