Forum

Custom Column forma...
 
Notifications
Clear all

Custom Column formatting Error

3 Posts
3 Users
0 Reactions
126 Views
(@kcrumrine828)
Posts: 1
New Member
Topic starter
 

I could have sworn this worked last month when I first created, but i am getting an error on my Custom column.

Expression.Error: We cannot apply operator - to types Date and Number. I have 4 columns that to create a count if an item was late or not based on the received date minus 5, since we have a 5 day buffer.

Here is one of my custom column formulas: if [#"[RCT]Date Received (Date)"]-5 <= [#"[PO]Due Date (Date)"] then 0 else 1

 

i've attached my source file as well as the TEMPLATE file that houses the power query. Thanks in advance for your help!!

Kasey

 
Posted : 30/05/2019 9:19 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Kasey,

You need to use the Date.AddDays function to adjust the date e.g.

if Date.AddDays([#"[RCT]Date Received (Date)"],-5) <= [#"[PO]Due Date (Date)"] then 0 else 1

Mynda
 
Posted : 31/05/2019 6:06 am
(@kcrumrine)
Posts: 2
New Member
 

Thank you, Mynda!! That was easy

Embarassed

 
Posted : 01/06/2019 8:37 am
Share: