Validation by Calculation

[wildasIwanabe]

Hi,

I'm having a problem trying to validate a field. I have 3 fields.

1) Job Status: This is a drop down with Won, Lost, Pending

2) Date Won: Date field

3) Sold For

Basically I don't want the Date Won field to be blank when Status=Won or when the Sold For field is not empty.

This is what I have so far, but it's not working. The validation message still comes up when all three fields are either entered or empty.

[color:red](not IsEmpty(Sold for) and not IsEmpty(Date Lost))

Any ideas on how I can do this?

[comment]

I don't want the Date Won field to be blank when Status=Won or when the Sold For field is not empty.

That could be written as:

not ( IsEmpty ( Date Won ) and ( Status = "Won" or not IsEmpty ( Sold For ) ) )

Edited April 23, 2009 by Guest

[wildasIwanabe]

Hi,

Thanks for the prompt reply. I tried your suggestion but I'm still getting the validation message when Status is NOT Won or when the Sold for field is empty.

[comment]

Sorry about that - I got distracted by noisy neighbors. Try the edited version.

[wildasIwanabe]

thanks a lot. That worked GREAT!

[comment]

I'm glad to hear that, because they're still at it...

:bang:

[mr_vodka]

You dont want to know where my mind went... :o

[comment]

:shocked: