Hello Dears,

I have a CSV table:

Events Date
Event_A, 11/18/2013 - (filter, don't show in front page)
Event_B, 11/19/2013 - {Today} or {Today}-7
Event_C, 11/20/2013
Event_D, 11/21/2013
Event_E, 11/22/2013
Event_F, 11/23/2013

How to ask ARI Data Table to filter past Dates, for example show record with Data starting from {Today} or data starting from the last week {Today}-7? Where {Today} is variable and changes depending on current date.

Like:
Filters:

# Column Name Operator Value
1 Date Show After... {Today}-7 (or {Today})

If not, can you please add an extension code with Date Operator and "Current Date" Value filters and Sort By Date?

Thanks in advance!

Hello,

The extension doesn't support this ability, but it can be done if show data from a database.

Regards,
ARI Soft

Hi

Im sorry for taking over someone elses thread. How can this be done (selecting data to show based on dates selected by user) but this time stored in a database?

Thanks

Hello,

It is possible to use request variables in "WHERE" clause of SQL query. You can read about it in this post.

Regards,
ARI Soft