Current Diaries on 10thOct

SELECT * FROM DIARIES
WHERE
  RECORD_DELETED = 0
  AND WEB_ENABLED = 1
  AND PRACTICE_ID = 1
  AND
  (
     ( ((INACTIVE = 0 OR INACTIVE IS NULL) AND ACTIVE_TO IS NULL) )
     OR
     ((INACTIVE = 0 OR INACTIVE IS NULL) AND ACTIVE_FROM <= '10/10/2014' AND
                                               ACTIVE_TO >= '10/10/2014')
  )
ORDER BY
  DIARY_NAME ASC