Liberum Help Desk
The free, open source solution for the web-based help desk.

time date format bug for search and reports

rated by 0 users
This post has 0 Replies | 1 Follower

Top 10 Contributor
Posts 23
Pete Posted: 06-08-2010 1:49 AM

search: /rep/results.asp

go to line 77 (search for start_date) and modify the line to match your local date format.

do the same for end_date.

reports:/admin/viewreports.asp

go to line 44 (search for start_date) and do the same as you did for the search.

 

This fixes the issue where certain search and reports fail to return a result because the date is interpreted wrong by sql as it uses the date format supplied by your sql server. Not sure if this affects access but I would assume it's the same.

The alternative is to change the date format on the sql server but it's a bit much for muchness.

Page 1 of 1 (1 items) | RSS
Copyright © Doug Luxem 2000-2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems