I am almost embarrassed to ask but given I couldn’t figure it out after 150 minutes of trying every conceivable method I could think of, so here I am.

I have an inline for querying Filemaker.
I want it to get all records with today’s date.
The field it is calling is a date field, which was extracted from XML submitted to the database.

Here is the inline.

[inline(
-database=’theDatabaseofInterest’,
-table=’tableSpecificallyforThisQuery’,
‘kioskofinterest’=$kioskID,
‘date_to_search’=$dateofToday,
-sortfield=‘a_timestamp_field’,
-sortorder='ascending’,
-maxrecords00,
-search
)]

Here is the variable I tried setting earlier in the page (it was one of many many attempts, but this one is the one I most expected to work as expected);

[var( dateofToday =( date->format('MM/dd/y') ) ) ]

if I just put [$dateofToday], I correctly show 01/26/2018
If I use that in the query by hand, it works just fine.

The page returns with zero records. There should be plenty of records returned.

Can someone guide me in the right direction to fix this?

Thank you,
Keith.

#############################################################

This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>