Loop with meta Query set on Toolset Date Time field

[SVIreland]

I am trying to achieve the same result as outlined in the following post but using a date/time custom field that is generated in Toolset and returns a numeric value in seconds:

SOLVED: Post Loop Meta Query by ACF Date Field

I’m interested in this too. Seeing if I can get this working from the Toolset DateTime custom field. I see that ACF is more compatible in areas like this. Would Metabox be similar?

I also have some feedback from Toolset support:

Using META Query in Bricks to filter by date. - Toolset

A number of things:

• the field is pulled in in the following format {ts_event-date-time} in the Bricks forum link I note that the result removed the {brackets} and the acc_ prefix.
• I see that ACF uses underscore while Toolset uses hypehns. Not sure if this makes a differnce.
• I am a bit confused betweeen the Meta Key and Meta Value fields in the example. The custom field can be accesed from the Meta Value dropdown but in the example this is placed into the Meta key field while the cuttent of the Meta Value is {current_date:Ymd}

From Toolset suport:

“If you are using something else to generate the query (in this case, Bricks), then the meta value you should be comparing against should be a timestamp (the PHP function time() would generate the current timestamp, for example).”

So I suppose I need some way to generate that timestamp and have it in the Mata Value field.

[SVIreland]

SOLVED: The way to do this is as follows:

• Meta Key: wpcf-event-date-time. Make sure to prefix your field slug with wpcf- The dynamic data mechanism with often prefix Toolset with ts- Ignore this prefix for certain use cases.

• Met Value: {current_date:U}. The uppercase matches UNIX epoch in seconds from the beginning of 1970. Toolset date/time fields are set in this format.

• For the type select NUMERIC.