Checking a Date field 2

[melburstein]

My Record Select formula currently says:

{@OrientationType} <> "DEPT" and
{Command.DATE-HIRED} = {?EnterDateRange}

It works fine. Now I want to expand it to NOT select records if there is a date in {Command.TERM-DATE}, a Date type field in an Oracle database, and that date falls within {?EnterDateRange}.

(I tried adding the following but it did not work)

and {Command.TERM-DATE} <> {?EnterDSateRange}

Can someone help me with the Formula?

 

[bdreed35]

Try this:

{@OrientationType} <> "DEPT" and
{Command.DATE-HIRED} = {?EnterDateRange} and
not({Command.TERM-DATE} in {?EnterDSateRange})


~Brian

 

[vidru]

There were 2 replies to your post in thread767-830600. If they didn't work out for you, just say so in the original post.

Thanks,

-dave

 

[melburstein]

I apologize for the double post. It was unintentional. I thought the original had not been posted.