how to make this trigger

[rcandeo]

Hi, I have a box that I put a trigger and when the user clik on it, will call a new tab.

The problem is that I wanna put in this trigger a date selection and I am not getting doing it.

Please which is the correct syntax?

I neee some like this:

>=$(vDateBegin) and <=$(vDateEnd)

[#2 · Accepted solution]

Please try this:

='>=' &date(vDateBegin)& '<=' & date(vDateEnd)

[mdmukramali]

Dear,

can you try the below syntax.

='>=' & Date(vDateBegin, 'M/D/YYYY') & '<=' & Date(vDateEnd, 'M/D/YYYY')

Thanks,

Mukram.

[rcandeo]

thank you very much