With Igor's help, I have this SQL statement that pulls out records based on
a start and stop date.
"SELECT Year, Month, Day, Open, High, Low, Close FROM [" & gsTableName & "]
" & _
"WHERE ((Month - " & lngStartMth & ")*100 + (Day - " & lngStartDay & ") +
1300) % 1300 <= ((" & _
lngEndMth - lngStartMth & ") * 100 + (" & lngEndDay - lngStartDay & ") +
1300) % 1300 " & _
"ORDER BY Year, ((Month - " & lngStartMth & ")*100 + (Day - " & lngStartDay
& ") + 1300) % 1300"
It worked well, except I added the 'Year' to the ORDER BY so that I could
get the information in this format:
(Example: 10/1 to 4/1)
1988 10 01 <data>
1988 10 02 <data>
...crossing the end of the year...
...into the next year...
1989 03 29 <data>
1989 03 30 <data>
1989 03 31 <data>
1989 04 01 <data>
...starting the next 10/01 to 04/01 extraction...
1989 10 01 <data>
1989 10 02 <data>
...
...
...and so forth.
Problem is that by adding the 'Year' to ORDER BY, while it does in fact give
me the above format, it also includes info I don't need. For example, when
it started at 10/01 for 1988 and ended the year, it then continued to 04/01
within the same 1988 year!
Any suggestions?
Thanks.
Rick
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
