Using a VARS in a query activity filter

Hi,

I'm trying to execute a query on nms:broadLogRcp table with a filter @eventDate AFTER $(vars/lastDate)
where  vars.lastDate is a global variable set in JS code in this way:

vars.lastDate = getOption("lastDateOption");
with lastDateOption -> DateTime type

The issue is that I always get 0 results from this query

You are able to understand how can I solve?

I believed that the problem was the DATE format, but I use a similar filter with a Integer number and I still get no results
I'm sure that in both the cases the filter shoud give N>0 results

Thanks in advance,

Salvatore

Jean-Serge Biron​

Adhiyan​

@nkur​

kirti.rawat​

Adobe Campaign​