@ June7 - This is probably the first time I've looked at the Choose() in 10 or so years so I'm not sure what it would do.
If it's a date datatype I don't think it can be null. Also not sure what [Task 011 Gap] is as it is being Added (+) to a date. [Task 011 Gap]+Choose([ . . .
Anything plus null = null.
This errors
Code:
Dim x As Date
x = Choose(4, #1/1/2021#, #2/2/2022#, #3/3/2023#)
Debug.Print x
this does not error. x as variant datatype which can be null
Code:
Dim x
x = Choose(4, #1/1/2021#, #2/2/2022#, #3/3/2023#)
Debug.Print x