DMXzone Database Connector ASP Support Product Page
Answered
Is it possible to filter records based on a dynamic date that is >= current date?
Asked 27 May 2014 21:44:27
1
has this question
27 May 2014 21:44:27 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 27 May 2014 22:05:23
27 May 2014 22:05:23 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:
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 28 May 2014 09:14:44
28 May 2014 09:14:44 Teodor Kuduschiev replied:
Hello Steve,
It is easier to just enter: now in the entered value field
It is easier to just enter: now in the entered value field
Replied 28 May 2014 13:45:45
28 May 2014 13:45:45 Steve Skinner replied:
Yes that would definitely be easier!