Table filter from date to date

[Standa]

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?

[maXim]

Hi Standa,

you're working with a database SQL-92 compatible o more?

The date field is a string?

If the date field is a string (not a date format) then:

<div align="left"><font face="Courier New"><font color="black"><font color="purple">q_Date_Start</font> = "<b>2008-07-01</b>"</font></font>
<font face="Courier New"><font color="black"><font color="purple">q_Date_End</font> = "<b>2009-03-30</b>"</font></font>
<font face="Courier New"><font color="black">xSQL = "<b>SELECT * FROM</b> <i><font color="sienna">[your table]</font></i><b> WHERE ((</b><i><font color="sienna">[date field]</font></i> <b>>= '</b>" & <font color="purple">q_Date_Start</font> & "<b>') AND (</b><i><font color="sienna">[date field]</font></i><b> <= '</b>" & <font color="purple">q_Date_End</font> & "<b>'))</b>"</font></font></div>

[Standa]

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.

[specci48]

Hello Standa,

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.


specci48

[Standa]

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 :-).