advanced filter show records active as of value?

how to get the date value specified in the advanced filter?

and how can i use that date to filter the records that will be retrieved?

To set a filter, just type in a date in the format defined in Windows and use the usual operators. E.g. >21/04/2014.

You’ll see the value in the form with advanced filters.

I mean if i select a date like this and press ok.

how do i retrieve the value of that field?

like in the picture how will i get 5/27/2013?


Aha, so this is not about normal ranges, this is about data effective data.

Get the instance of the query and call validTimeState*() methods, such as validTimeStateAsOfDate().