Hello Experts, 

I am trying to calculate a day count between 2 dates [FundingDate],[LastBdMo] but I need to add a where condition.  I am not sure if I can do this?  I have added the blue below and the query runs but the column is returning a #error. 

I assume I cant add a where condition but maybe an expert has another idea.  

DayCount: Abs(DateDiff(“d”,[FundingDate],[LastBdMo],“TypeIDfk = ” & [tblFacility].[TypeIDfk]))

thank you…

let me know if not clear. 

​Hello Experts,  I am trying to calculate a day count between 2 dates [FundingDate],[LastBdMo] but I need to add a where condition.  I am not sure if I can do this?  I have added the blue below and the query runs but the column is returning a #error.  I assume I cant add a where condition but maybe an expert has another idea.   DayCount: Abs(DateDiff(“d”,[FundingDate],[LastBdMo],”TypeIDfk = ” & [tblFacility].[TypeIDfk])) thank you…let me know if not clear.   Read More

​