AOW not triggering on records

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

I’m having a problem with this workflow not triggering properly. When the event date is set to today (‘now’) this should trigger and run on events correct?

2

also I am running 7.1.1

3

try setting it to greater than or equal to, instead of equal to

4

Changed and tried, even with a new workflow. Still no go, its just no triggering correctly with dates. Any other ideas or reported bugs?

5

I did some digging and I know ‘what’ is wrong but not how to fix it… I am pretty sure it is a bug…
When setting up the workflow I selected equal to date now, it created an invalid SQL statement, this is what it created:
SELECT accounts.id AS id FROM accounts LEFT JOIN accounts_cstm accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts_cstm.event_date_c = DATE_ADD(NOW(), INTERVAL ) AND accounts_cstm.booked_video_c = ‘1’ AND accounts.deleted = 0

The problem is there is that i didn’t specify or want an INTERVAL to the date ‘now’. . . . See the problem anyone? Know how to fix it?

I was able to do a work around of setting it up equal to or greater than NOW plus 1 minute.