tazeo
Board Regular
- Joined
- Feb 15, 2007
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
So I have a column called Due Date, which comes across from excel as text, it will always have a couple of null entries.
I want to change these to a date preferably 14 days into the future.
Have read how I should be able to do this in the column, without creating a new one, but I can't even get it to change the null to a dummy date.
I have tried changing the column to a Date one, and the change null to a dummy date (1/1/2023) = Table.ReplaceValue(#"Changed Type",null,#date(2023, 1, 1),Replacer.ReplaceValue,{"Due Date"})
and then adjust the #date(2023, 1, 1) with something like DateTime.LocalNow() but it isn't working. If I get this right I believe I will be able to just add the days, but need to get the previous step sorted first.
I am sure I probably have headed down the wrong path, so rip it to shreds
Thanks in advance
I want to change these to a date preferably 14 days into the future.
Have read how I should be able to do this in the column, without creating a new one, but I can't even get it to change the null to a dummy date.
I have tried changing the column to a Date one, and the change null to a dummy date (1/1/2023) = Table.ReplaceValue(#"Changed Type",null,#date(2023, 1, 1),Replacer.ReplaceValue,{"Due Date"})
and then adjust the #date(2023, 1, 1) with something like DateTime.LocalNow() but it isn't working. If I get this right I believe I will be able to just add the days, but need to get the previous step sorted first.
I am sure I probably have headed down the wrong path, so rip it to shreds
Thanks in advance