Any reason qhy a query like this would not work?
myDateCol >= '2004/10/1 00:00:00' and
myDateCol < '2005/11/1 00:00:00'
Originally posted by AskSQLTeam
Harold writes "I have multiple years worth of data and would like to return the current fiscal years data only. In my example records from Oct. 01 through Sept 31 02 would be this fiscal year."