Hello,
I have table where one row of record contains date in format "yyyy-mm-dd". Is there some way how to make filter, for example from 7th month 2008th year to 3th month 2009th year?
Hi maXim,
there is little problem , I have used only simple table control, not sql. Because in the table will be not more than 250 records a year.
So is this filtering possible in the table control or have I use sql?
And yes, date is string format.
it is not possible to filter a "range" from a column which type is "cString".
A possible solution is to add a hidden table column (width = 0) of the type cNumber which contains the time or date information saved in ticks. This column could now be filtered easily for time ranges.
Hey specci48 thank you!
This is what I already thought about - to make hidden column with cNumber value, but I did not know, how to make hidden column. Trick with width = 0 is smart, thank you .