Blank or Null Date Validation

I am trying to write basic if condition considering date field, there are chances of blank in date field. I am aiming to name blank fields based in if loop. Below is the condition I write but for eac...

Need Help

DoubleJ

6 years ago

I would suggest that you use the ISBLANK() check as first condition.
Personally I prefer a SWITCH() to nested IFS(). The code could look like this:

Lifecycle = 
SWITCH(TRUE(),
ISBLANK(POC_SBSPN_LIFECYC_ACTUAL[Schd Dt]),"Never Active",
POC_SBSPN_LIFECYC_ACTUAL[Schd Dt]>=TODAY()-30,"30DayActive",
POC_SBSPN_LIFECYC_ACTUAL[Schd Dt]>=TODAY()-90 && POC_SBSPN_LIFECYC_ACTUAL[Schd Dt] < TODAY()-30, "Inactive",
POC_SBSPN_LIFECYC_ACTUAL[Schd Dt]<TODAY()-90,"Dormant",
"Other")

Hope this helps!
JJ

Forum Discussion

Blank or Null Date Validation

Related content

Replace Values Null to Blank or Blank to Null

Counting nulls

Replace blanks with null

Replacing null values with blank

Blank or null value