Power Query Help with a date formula

[gheyman]

This doesnt seem to work. Can someone point out my error?

thanks

= Table.AddColumn(#"Filtered Rows3", "Custom.1", each if [ApprovalDate] > DateTime.Date(09/09/2022) then Date.AddMonths([Effective Date], 18) else "N")

it results in Error

 

[lrobbo314]

According to the documentation you would use the DateTime.Date function like this...

DateTime.Date(#datetime(2022, 09, 09, 11, 56, 02))

But, I think you might want to use DateTime.From like this...

DateTime.From(#date(2022, 9, 9))

 

[gheyman]

Thank you, that worked. Very much appreciated.