overlaping two date periods

to return an action with start and end date in case overlapped with a given date range

"( (@ActionDateFrom is null) or (@ActionDateFrom !> TruncateTime(it.Action1.ActionEndDate)))

and ( (@ActionDateTo is null) or (@ActionDateTo !< TruncateTime(it.Action1.ActionStartDate)))"