How to make a reference field use another field on the form

[Community Alums]

I could you a little assistance with trying to get a reference qualifier to work correctly

I am on the ast_contract table.  I have a new field called u_renewal_contract which I would like to reference the ast_contract table and filter the results with the criteria of Client name where contracts date between 3 months ago and 3 months in the future.

Information on what I have tried:

If I just do an advanced reference on the ast_contract table using the following: (The @&colon in the javascript should be just a : not : the editor is changing it.)

javascript:"u_company=" + current.u_company

I get a list of all of the contacts that the company has, which is part of the required results.

What I'm having problem with is now I want to add where the date of a field is between the last 3 months and the next quarter.  So I tried the following to get the contracts that are in that range

u_fns_est_go_live_dateBETWEENjavascript:gs.beginningOfLast3Months()@javascript:gs.endOfNextQuarter()

 This returns all of the contracts that fall in that range, Perfect right?  well it doesn't filter to just the company in the u_company field on the current form.  So I tried this:

javascript:"u_company=" + current.u_company^u_fns_est_go_live_dateBETWEENjavascript:gs.beginningOfLast3Months()@javascript:gs.endOfNextQuarter()

This reference qualifier basically negates everything and brings back all the records.

How can I marry the first reference qualifier and the second reference qualifier together to bring back the records for that company that are between the dates.  I though a ^ would join the two but that's not working.

Thanks in advance

[Alex Rose]

I believe you need to put the ^ in quotes e.g. 

"u_company=" + current.u_company + "^" + u_fns_est_go_live_dateBETWEEN...

[Community Alums]

That did not work, I have tried to update with that and same results as without it.