Forum Discussion
Replace future dates by today date
- 6 years ago
Hello NumeroENAP
as far as I know the function Table.ReplaceValue just replaces and old value with a new value. Use this syntax instead (not tested)
= Table.TransformColumns ( #"Column", { { "Date created", each if _ > Date.From(DateTime.FixedLocalNow()) then Date.From(DateTime.FixedLocalNow()) else _, type date } } )
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy - 6 years ago
Try:
= Table.ReplaceValue(#"Column", "Date created", each if DateTime.FromText([Date created])> DateTime.FixedLocalNow() then DateTime.FixedLocalNow() else [Date created])
Hello NumeroENAP
just saw that this formula was accepted as solution.
Table.ReplaceValue(#"Column", "Date created", each if DateTime.FromText([Date created])> DateTime.FixedLocalNow() then DateTime.FixedLocalNow() else [Date created])
it can not work, did it?
All the best
Jimmy
Jimmy801, you are correct. My suggestion makes it accept teh formula without giving an error, but doesn't change the date as intended.
Your answer should be the one marked as solution as it returns the expected result in onwe step.