"Yes" if Date difference (hours/duration) is met

[rfigueroa1976]

June7, I'm not sure what you are asking for. Did you want a screen shot?

[rfigueroa1976]

I figured it out y'all... It was the way i have the formula layed out...

I originallly had it as: Delivered Passed 15 MIN Window: IIf(DateDiff("n",[dbo_stops].[stp_arrivaldate],[dbo_orderheader].[ord_dest_latestdate])<15,"No","Yes")

I changed it to: Delivered Passed 15 MIN Window: IIf(DateDiff("n",[dbo_orderheader].[ord_dest_latestdate],[dbo_stops].[stp_arrivaldate])<15,"No","Yes")

Just needed to switch the order of the field names and it fixed it. I'm now getting the results i needed.

Thank you all again!!!!!