Error generating list of dates

[pbrainard]

I need to create a list of dates between an Enrollment Date and a Dismissal Date. I can do that with this...
= Table.AddColumn(#"Renamed Columns4", "csActiveCaseDates", each {Number.From([csEnrollDate])..Number.From([csDismissDate])})

Then converting the data type to Date.

Issue I'm having is Some of the Dismissal Dates are null because the cases are still Active, so when I click Close and Apply I get this error...

We cannot apply operator to null and date

How can I modify my add column formula to make the nulls today's date?

[pbrainard]

Perfect. Thank you.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Write this custom column formula in the Query Editor and name the column as Revised csDismissDate 

=if [csDismissDate]=null then DateTime.Date(DateTime.LocalNow()) else [csDismissDate]

In your formula, refer to this newly created column.