• SELECT *

    FROM

    WHERE valuedate '20070731'

    and valuedate '20070724'

    -- Gianluca Sartori