Searching between 2 dates on a DateTimeStamp field

[mikeowen]

Hi,

I wonder if anyone out there can help me!

I am trying to figure out the SQL to query some records based on the date contained in a / the DateTimeStamp field. The information in the field seems to be held in Julian format, which I presume is typical.

E.g. If the from date was '1 Feb 2011', and the to date was '15 March 2011' ?


Thanks, Mike.