datatable.compute method

[Guest]

I'm trying to compute the minimum datetime of a column in a certain datetime
range like so:

datatable.compute("Min(datetime_column)", "datetime_column < datetimeobject");

I get a syntax error.....I suppose this has something to do with compute
encountering a colon in my datetime and throwing a hissyfit. Is there some
way I can do this? You can compare datetime objects easily outside of a
compute call, so what gives?

 

[Cor Ligthert]

David,

I always thought that working with datetimes in an expression was a crime
and now I see that your problem is even on this page.

http://msdn.microsoft.com/library/d...frlrfsystemdatadatatableclasscomputetopic.asp

colDate > 1/1/99 AND colDate < 17/1/99

That are strings no objects.

Thanks for this messages, it added to my knowledge.



Cor