You might need to use to_date (or your DB's equivalent) to turn the first and last dates from strings to the date type. Assuming you haven't done this already.
Have you fixed it?furzepigAugust 30 2006, 11:30:05 UTC
I don't think we know each other, but your post brought back horrible memories I have of many days of troubleshooting a similar problem.
In my case it was to do with the date format - I had to output the date in ODBC format, then analyze it. My solution wouldn't solve your problem (as it was in Cold Fusion based code calling data from SQL server) but I recommend pursuing the date format angle if you haven't solved it already!
Apologies for inappropriate spamming if this is no use to you.
Re: Have you fixed it?scary_ladyAugust 30 2006, 14:05:56 UTC
Very kind of you, and also correct.
I didn't actually work out exactly why it didn't work in the end. I found an online help page that displayed the query. It looked EXACTLY the same as mine. However, when I copied and pasted the date format from that query to mine and carefully replaced the example dates with my dates it worked.
Comments 4
Reply
Reply
In my case it was to do with the date format - I had to output the date in ODBC format, then analyze it. My solution wouldn't solve your problem (as it was in Cold Fusion based code calling data from SQL server) but I recommend pursuing the date format angle if you haven't solved it already!
Apologies for inappropriate spamming if this is no use to you.
Reply
I didn't actually work out exactly why it didn't work in the end. I found an online help page that displayed the query. It looked EXACTLY the same as mine. However, when I copied and pasted the date format from that query to mine and carefully replaced the example dates with my dates it worked.
I still have no idea why.
Reply
Leave a comment