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...
Forum Discussion
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
------------------------------
IF(not IsNull([my date field 1]), [my date field 1], my formula goes here)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
When I try to use the formula, Is says it's looking for more.
If(not IsNull([I-INDOC Continuing Qual Date]),[I-INDOC Continuing Qual Date],(AdjustMonth([I-INDOC Qualification Date], 36)-Days(1))
It say it's expecting ), at the end
------------------------------
Tony Miller
------------------------------
If(not IsNull([I-INDOC Continuing Qual Date]),[I-INDOC Continuing Qual Date],(AdjustMonth([I-INDOC Qualification Date], 36)-Days(1))
It say it's expecting ), at the end
------------------------------
Tony Miller
------------------------------
- Try this
If(
not IsNull([I-INDOC Continuing Qual Date]),[I-INDOC Continuing Qual Date],
AdjustMonth([I-INDOC Qualification Date], 36)-Days(1))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Thanks again Mark. That did work, but (due to my inability to ask clearly for what I need), it did not work as I was thinking it would.
This is what I have (screenshot):
I need the formula in I-INDOC Expiration Date to look for a date in I-INDOC Continuing Qual Date, first, if null, then look in I-INDOC Qualification Date. If a date is in I-INDOC Continuing Qual Date, then calculate on that date. Make sense?
------------------------------
Tony Miller
------------------------------- @Tony Miller Sorry but I read this several times
I need the formula in I-INDOC Expiration Date to look for a date in I-INDOC Continuing Qual Date, first, if null, then look in I-INDOC Qualification Date. If a date is in I-INDOC Continuing Qual Date, then calculate on that date.
and I don't understand the "ask". Can you explain it more clearly or else show what the calculated result should be with several examples illustrating all the different scenarios?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
