Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Fri, Oct 24 2008 3:24 AM	Permanent Link
Hiba Hable	Hello, How can I write sql statment for which i want to get all the records where date is between a 2 specific dates. I tried to use cast but didnt work! Thx Hiba
Fri, Oct 24 2008 5:04 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Hiba There was a post about this recently. The dates need to be in ANSI format eg SELECT * FROM table WHERE datefield BETWEEN '2008-01-01' AND '2008-08-07' Roy Lambert