Pipeline expression for date = date

Question

I am trying to create a pipeline that searches a record where a date in step A matches a date in step B, but the only options on the pipeline is where the date is:
set, not set, before, after, between, not between, more than or less than
equal to is not an option here.  Is there a way to use an expression instead to say where date in step A matches date in step B?------------------------------Amber Goodman------------------------------

ChayceDuncan · Answer

If you're doing a search the query syntax be b {'fid'.EX.'value of date'} so something like:

{'fid'.EX.'{{a.date}}'} where fid is the field ID of the date you're searching for in the secondary table being targeted.

------------------------------
Chayce Duncan
------------------------------

Sign up

Login to the community