Why does "select * from events" only show the result of schedules on today?

[goodboy]

To get results of client schedules on 06/20/2009, I use the query "select * from events where date(scheduled_start)='06/20/2009'". But I don't get anything. If changing the query to "select * from events where date(scheduled_start)='06/22/2009", TSM gives me the results of 06/22/2009 (06/22/2009 is today).

Do not use SQL query, I use the command "q event standard sche_name begind=06/20/2009 endt=06/20/2009". I can get all I need.

Why does TSM only give the result of today when using "select ..." command? How can I use select command to get records of previous days?

Thanks for any response!

 

[Phil_02GT]

You have to use ...where date between...

 

[cjhood]

goodboy,

See these posts:

http://www.adsm.org/forum/showpost.php?p=70479&postcount=4
http://www.lascon.co.uk/d005104.htm#sqltabs

The Events table doesn't work like other tables do, in that it is generated on the fly for anything older than the current day (thanks Mason_Love). You need to hack around the date field as shown in the links.

-Chris

 

[goodboy]

That's great. Thanks Phil and Chris (and Mason_Love also)!