DMXzone Database Connector ASP Support Product Page

Answered

Is it possible to filter records based on a dynamic date that is >= current date?

10 years ago Steve Skinner posted:
In regular DW recordsets, this is easy, but using the new behaviors, I was wondering what you would enter into this box if you wanted to filter records to show only those with a date field that is >= the current date.



Is this possible with the new behaviors and what would you enter for the filter?

Replies

Replied 10 years ago
10 years ago Steve Skinner replied:
I figured out the answer to my own question here... so I thought I would share in case this comes up for others in the future.

Instead of using "entered value" for the filtering option, I used form variable and inserted a hidden form field on the page and used code to populate the value of the hidden field with the current date.

In this case, I'm on a site using classic ASP and that code is:
<%= Date %>

Replied 10 years ago
10 years ago Teodor Kuduschiev replied:
Hello Steve,
It is easier to just enter: now in the entered value field
Replied 10 years ago
10 years ago Steve Skinner replied:
Yes that would definitely be easier!

Reply to this topic