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

[swuehl]

Could you please post some more details on how the field values look like, how the variable looks like and how the search string is defined.

If possible, you can also just post a small sample QVW.

[Chanty4u]

hi,

if ur date format  :  DD.MM.YYYY

You could possibly have a problem in the search string. It uses decimal comma, but the field has decimal points. You should use the same decimal separator in both places.

or

There was a link between both tables..  u can remove the link  and try.

[vikasmahajan]

Hi,

Do this script changes

MaxDate:

Load

     Date(max(PostingDate),'DD-MM-YYYY') as vMaxDate

From [..\Qvds\Sales.qvd] (qvd);

Go to Sheet -> Trigger -> On Activate Sheet-> Select in Field -> Select Month Field -> Sales_month

Enter    =Date(max(vMaxDate),'MMM-YY')  in search String  automatically the month will be selected.

Hope this will help you.

Vikas

[Digvijay_Singh]

see if this can help -

[#6]

The variables defined in the load script:

/ 
LET vPreviousMonthStart = monthstart(today(),-1);
LET vPreviousMonthEnd = monthend(vPreviousMonthStart);

[swuehl]

What about a search string

=SALES_D_COSTED=vPreviousMonthStart

[swuehl]

Also try

='$(vPreviousMonthStart)'

which should replicate your literal value (you can also check the result of the search expression in a text box first).

[#9]

I did try this, unsuccessfully.

Thanks

[#10]

Tried this, no success, sorry.