gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
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
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