Filter Dates in Tables

On thing I think it is missing in WinDev XII new Filter in Tables feature, or maybe I did not find how:

One common Filter for Dates are periods (start and end date). It was very usefull to filter "Between", for Dates and also for values.

Can someone give the best aproach for solving this?

Thanks in Advance.




Message forwarded from pcsoft.us.windev

Hi Luiz,

Generally I populate my table views with a query. If you do this then you can set the display to filter between dates which are either inserted manually in the code or populated via paramaeters from the query.

If you use parameters you can populate them via a window as variables or by coding if you don't want to display a window before displaying the table.

HTH

Milton

Translation of BETWEEN:
sql ->MyDATE BETWEEN OldestDATE AND YoungestDATE

wl -> OldestDATE <= MyDATE <= YoungestDATE