Scheduler date range does not work

nokiadatagathering / ndg-ng

4.04 up to 5.11 versions of the server

5 stars 6 forks source link

Scheduler date range does not work #69

Closed leGeddy closed 11 years ago

leGeddy commented 11 years ago

It appears that selecting date range with transaction_log.transaction_date does not work. But using ndg_result.date_sent does.

IanLawrence commented 11 years ago

Not sure what you mean here. Do you mean that the scheduler is not working as currently implemented or works but does not get the correct date range without modifying the query to use ndg_result.date_sent ?

leGeddy commented 11 years ago

It's currently working but the query needs to be changed because it returns results outside of the date range. The transaction_date format is not yyyy-mm-dd so the query fails. Besides, it's simpler to use ndg_result.date_sent...

IanLawrence commented 11 years ago

Ok thanks..will change that