Hello,
Using DBISAM 4.25 build 4, Win XP Pro, D2007...

I have the following SQL statement but I get "7/12/2006' is not a valid date'. error...

Here is the sql statement...

Select AVG(Lat) from HModelSort where (Name = 'AP14' or Name = 'AVNI' or Name = 'VANO') AND
(BaseTime = '7/12/2006 6:00:00 AM') AND (ForecastTime = '7/12/2006 9:00:00 AM')

My table has the following structure:
Name : string
BaseTime : TimeStamp
ForecastTime : TimeStamp

Any suggestions on what might be wrong?
Thanks!
Bryan

Hi Bryan,
Dates have to be in ansi format ie ccyy-mm-dd.

Donat.

"Bryan" <bryan@extremewx.com> wrote in message
news:57CE3D12-C66E-4479-974F-A184A72B5D24@news.elevatesoft.com...
> Hello,
> Using DBISAM 4.25 build 4, Win XP Pro, D2007...
>
> I have the following SQL statement but I get "7/12/2006' is not a valid
> date'. error...
>
> Here is the sql statement...
>
> Select AVG(Lat) from HModelSort where (Name = 'AP14' or Name = 'AVNI' or
> Name = 'VANO') AND
> (BaseTime = '7/12/2006 6:00:00 AM') AND (ForecastTime = '7/12/2006 9:00:00
> AM')
>
> My table has the following structure:
> Name : string
> BaseTime : TimeStamp
> ForecastTime : TimeStamp
>
> Any suggestions on what might be wrong?
> Thanks!
> Bryan
>

"Donat Hebert \(Worldsoft\)" <donat.hebert@worldsoft.ca> wrote:

Hi Bryan,
Dates have to be in ansi format ie ccyy-mm-dd.

Donat.

Thanks!  That did the trick.

Bryan