How to check between dates and include Nulls

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?

Custom Tools

Accepted answers

PanPP

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.

PanPP

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

All comments

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.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177