PowerQuery solving date value to retain

[hannouech]

Hello,

I have a table tracking the invoices from suppliers of the month of feburary, but there are some invoices of month of january received in februaray, I have to replace them by 01/02/2018.

I have to solve this by powerquery, so when I import the transactions of march, the invoices with dates before 01/03/2018 have to be replaced by 01/03/2018 and so on for the following month.

Thanks a lot

This a link to the file

https://www.cjoint.com/c/IAhnPFMEw8A

 

[Ron Coderre]

My employer blocks access to the link you posted.
I created a table of dates in a column labeled "MyDates" and included this M-code in my query:

= Table.TransformColumns(#"Changed Type",{{"MyDates", each if _ < #date(2019,2,1) then #date(2019,2,1) else _, type date}})

Is that something you can work with?

 

[hannouech]

My employer blocks access to the link you posted.
I created a table of dates in a column labeled "MyDates" and included this M-code in my query:

= Table.TransformColumns(#"Changed Type",{{"MyDates", each if _ < #date(2019,2,1) then #date(2019,2,1) else _, type date}})

Is that something you can work with?

It dosent work

Would you please make it on the file and send it to me???