Forum Discussion
Expression.Error:We cannot apply operator + to types Date and Number
Hi I keep the above error even after changing data type to Date.Trying to create a new custom column based on another column. This was the excel formula =IF(AND(AM2="M",OR(AL2="",AL2<TOD...
Table.AddColumn(CBCEventcalc, "PCF Event calc", each if DateTime.From([PCF Event]) = DateTime.From("M") and DateTime.From([Estimated Pickup] = DateTime.From(null) or DateTime.From([Estimated Pickup]) <= Date.From(DateTime.LocalNow()))then
"PCF"
else
"")
Even i tried this but still throwing error. Please provide some advice
Even i tried this but still throwing error. Please provide some advice