Forum Discussion
Solved
Error generating list of dates
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([csEnrollDa...
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.
Perfect. Thank you.
You are welcome.