09-29-2018, 04:19 PM
This should fix the send reminder issue.
https://github.com/tsolucio/corebos/commit/041483da08c108ec78c6dc24c3ad105e05cf7432
when you select "today" the query that is constructed has the condition "between today 00:00:00 and today 23:59:00", activate the debug query and you will see it.
this is the condition I see in my tests:
WHERE vtiger_activity.activityid > 0 AND vtiger_crmentity.deleted=0 and vtiger_activity.dtstart between '2018-09-30 00:00:00' and '2018-09-30 23:59:00'
https://github.com/tsolucio/corebos/commit/041483da08c108ec78c6dc24c3ad105e05cf7432
when you select "today" the query that is constructed has the condition "between today 00:00:00 and today 23:59:00", activate the debug query and you will see it.
this is the condition I see in my tests:
WHERE vtiger_activity.activityid > 0 AND vtiger_crmentity.deleted=0 and vtiger_activity.dtstart between '2018-09-30 00:00:00' and '2018-09-30 23:59:00'
Joe
TSolucio
TSolucio