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
- TheDataMustFlow6 years agoFrequent Visitor
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.
- NumeroENAP6 years agoHelper III
Sorry Jimmy801 , in fact, I worked around the answer that he gave me and it worked.
But I corrected the situation and gave you the proper credit.
Thanks for the answer!
- Jimmy8016 years agoCommunity Champion