Fix custom column, error when subtact date column from another date column

[Anonymous]

I'm gettng an error when I subtract one date column from another date column in Power Query.

Here is the formula I have to crate my column which subtracts one date column from the other date column

= Table.AddColumn(#"Determine Quick vs Not Quick", "Delivery Date less PO Date", each ([#"Created On (PO)"]-[#"Delivery (from Delivery Dates)"])*1)

Both of the columns are formatted as date columns.

Here is the error I receive after I close Power Query.

[Anonymous · Accepted solution]

Hi @Anonymous,

The calculate between two date fields should be a duration, you can't direct convert it to date type. I'd like to suggest you use the duration type to store the result.
After these steps, you can simply use duration functions to extract different units from duration value. (such as day, hour, minutes...)

AddColumn= Table.AddColumn(#"Changed Type", "Custom", each Duration.From([End]-[Start]))

Duration functions 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Sample data would really help to recreate this but it seems like you are changinge that column to a Date column, but a subtraction between two dates will not result in a date, it would result in the number of days, a whole number value?