im trying to find columns that have a date difference of 6 days between two columns.
im using the following logic
(Instr_DM_Type == "FX" && [Instr_DM SubType] == "FX Forward") && ((DATEDIFF("dd",(DT_DATE)[Instr_Expiry Date],(DT_DATE)[Report_End Date]) < 6)? "CFX" : [Instr_DM SubType]
but it doesnt seem to be working correcly as some of the dates are coming back as a minus and so the logic fails. any ideas how i can do it