Skip to Content
0
Former Member
Feb 26, 2009 at 04:53 PM

Formula to look for a blank date field

2906 Views

I need to write a formula to check to see if a date field isn't blank. I can successfully write a formula to see if the date is blank, but I'm having problems checking to see if it isn't blank. I don't want to compare the field to current date or any other date; I just want to determine if it isn't blank.

I've tried:

If not null, if not equal to "", (using the not equal sign) etc. and I keep getting errors.

This is the field I'm trying to determine if it isn't blank: {TRACKING_FILE.f7070#price_lock_exp_date}

Any help will be appreciated.