Forum Discussion

Qrew Member

3 years ago

Formula Help

I'm attempting to write a formula where it looks for a date in "Date 1" and if there is a date, then do a calculation. If there is no date in "Date 1", then use "Date 2" and calculate. I wan...

Formulas and functions

MarkShnier__You

Qrew Legend

I can't edit a screen shot so in future you will receive better answers if you copy and paste your formula, but you want something like this

IF(not IsNull([my date field 1]), [my date field 1], my formula goes here)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

TonyMiller

Qrew Member

3 years ago

Sorry about that. I'll remember next time. New to using the forum. Thank you for the help.

------------------------------
Tony Miller
------------------------------