Action - Select in field with variable

[Anonymous]

Hi,

I am trying to make an action based on input field of an variable and select in Field the values [Data Sales ]that are greater than vStartMonth.

The versions: '>=$(vStartMonth)', '>=vStartMonth' are not working. If i put '>=4/1/2014' it works. My variable vStartMonth is 4/1/2014.

Any suggestion regarding the format?

Thank you,

Cosmina

[sunny_talwar]

May be formatting is different or you need to have it read as date? Can you share what is the definition of vStartMonth? Is it hardcoded or an expression?

[Anonymous]

Hi,

I have attached a sample at what i want to do. In the Action button, i don't know which is the syntax for filtring data with variable.

Thank you,

[sunny_talwar · Accepted solution]

This seems to working

='>=' & vStartDate

[Anonymous]

Thank you