While trying to this in a postgres node
Execute Query
select leads.id, leads.leadName,activitylog.activity,activitylog.rawdata,activitylog.timedate
from activitylog
left join leads
on activitylog.leadname = leads.leadname
where activitylog.timedate > date ‘11/04/2021’ + time ‘01:43:02’
and leads.leadname = ‘[email protected]’
order by timedate
limit 1;
I always recieve this error back even tho every time I used it like this it worked