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.