Date evaluation with Null value using IIF Function (1 Viewer)

[TIO OLAN]

Hello!

Im just want to ask help on my queries with having 5 types of Dates and some of them is having a null value. What would be the best formula or calculation to add the following initial expression including dates with null values:
IIf([DATE]>Employee Hire+60,"Production","Nesting"),
IIf([Date]>=[DatesProduction Start],"Production",
IIf([Date]>=DatesNesting Start],"Nesting",
IIf([Date]>=DatesTraining Start],"Training","Unknown")))))

I have these initial formula but it is not include the date with null values or blank. The following details are the sample dataset with null values and still looking for answers. Asking for help to solve these by using Iif function:?

Data Date	Hire date	Training Date	Nesting Date	Production Date	Should be Employee status
8/12/2022	7/18/2022	0 or Null	8/8/2022	0 or Null	Nesting
8/1/2022	11/8/2021	0 or Null	11/22/2021	12/4/2021	Production
8/5/2022	7/18/2022	0 or Null	8/15/2022	0 or Null	Nesting

Thank you very much

 

[theDBguy]

Hi. Welcome to AWF!

Are you trying to compare those date fields to the current date?

 

[TIO OLAN]

Hi. Welcome to AWF!

Are you trying to compare those date fields to the current date?

Yes Thank you for your reply

 

[arnelgp]

correct me if wrong, but from what you showed, Employee Status is based on which Date is not Null?

Switch(IsNull([Production Date]) = False, "Production", IsNull([Nesting Date]) = False, "Nesting", IsNull([Training Date]) = False, "Training", True, "Unknown")

 

[TIO OLAN]

correct me if wrong, but from what you showed, Employee Status is based on which Date is not Null?

Switch(IsNull([Production Date]) = False, "Production", IsNull([Nesting Date]) = False, "Nesting", IsNull([Training Date]) = False, "Training", True, "Unknown")

The remarks stated under Employee Status should be my final result in database and I did not get that status because of having null values in some dates like showing in the sample table. Just I dont find best formula to show that Employee status in my database sir.

Thank you very much for the help