How to check between dates and include Nulls

[wonka1234]

Hi,

I have this formula: 

IF
([Date1] > '2022-11-01') AND ([Date2] < '2023-12-31')

THEN Null()
ELSE 'Columns has dates outside November'
ENDIF

but if Date 1 or Date 2 column have Nulls in them, how do I take in account for them? Wont I get Nulls if I dont have a date?

[PanPP]

Hi @wonka1234 

You can account for the null in a column using the isNull() expression

You can also replace these nulls with a blank value referenced by ""

Hope this helps. Please let us know if you have any other questions.

[wonka1234]

@PanPP 

having trouiule wrapping my formula to account for nulls. 

New column:

IF
([Date1] > '2022-11-01') AND ([Date2] < '2023-12-31')

THEN Null()
ELSE 'Columns has dates outside November'
ENDIF

But what if Date1 or Date2 columns have a null int hem? I need a way to handle those nulls and count those rows as a Null.

[PanPP]

I believe you are looking for a formula that is shown in the image below.

[wonka1234]

@PanPP 

thank you, what if I wanted to change your Row 4 "Date Final" to be Null as one of the values there is null?

[PanPP · Accepted solution]

Please see the second formula in the screenshot below.

Please like this post if this helps and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[wonka1234]

Thanks!! @PanPP 

Just for my own knowledge - is there a way to wrap this in one formula?

[PanPP · Accepted solution]

Hi @wonka1234 

You can use the following formula to achieve the same result. Please see below.

if ([Date] >= "2022-11-01" and [Date] <= "2023-12-31") then "" elseif IsNull([Date]) then "" elseif IsNull([Date2]) then "" else "Outside November" endif