Forum Discussion
Helper IIIError 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([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?
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.
3 Replies
- Ashish_Mathur
Super User
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.
pbrainardPerfect. Thank you.
- Ashish_Mathur
You are welcome.