Having a bit of a challenge with trigger on a sheet

[#1]

I want to set up an OnActivate trigger to do Select in field.

When I do this using a literal value for the Search String component, this works.

When I do this using a variable that has been loaded, it does not appear to work.  The variable represents the 'Prior Month Start Date', and the Field component of the Select in field is set to a date like 'sales_date'.

Any ideas or suggestions?

Thanks

[#2]

Consulted with another team member, and we came up with this:

='>='&(vPreviousMonthStart)&'<='&(vPreviousMonthEnd)

Which appears to work.

[swuehl]

I assume you have checked in a text box that my second suggestion does replicate the literal you put in and made it work.

Could you post a small sample QVW that demonstrates your setting?

[swuehl]

Ok, glad that it works now.

Seems like you are trying to select a date or timestamp range, I guess there just isn't an exact match with the previous month start date.

If all issues resolved related with your original post, please close this thread, by marking one of the answers as correct (or set the thread to 'Assumed Answered', if you want).