Hello,
For date comparison all values must be of date type. Your query will return no records as you are trying string comparison, BETWEEN will not work as expected.
CONVERT(VARCHAR(11), CreateDate, 103)
I suggest you change your SQL to
SELECT JobTitle, CONVERT(VARCHAR(11),CreatedDate,103) FROM JobForm
WHERE CreatedDate BETWEEN CONVERT(DATE,'09/02/2013',103) AND CONVERT(DATE,'06/03/2013',103)
Regards,