niiantiaye
Posts: 9
|
| Posted: 03/12/2013, 11:55 AM |
|
Hi , I am a newbie and need help. I have created my report and would like to display records filtering them by date of birth field. I would like a user to choose a date range for eg. choose customers whose date of birth are within one date to another date. How do I achieve this using ccs. I am also new to php
|
 |
 |
Gena
Posts: 591
|
| Posted: 03/12/2013, 12:23 PM |
|
this is quit easy.
Create a Search from with the 2 fields, set it as Date fields and assign also Calendar control for both.
In you Grid add WHERE condition like
s_FirstDate <= your_date
AND
s_SecondDate >= your_date
set appropriated date format...
you can even to create form using Search Builder for your existing Grid, create just for 1 field, then add another and change WHERE conditions...
_________________
Gena |
|
|
|
niiantiaye
Posts: 9
|
| Posted: 03/12/2013, 2:13 PM |
|
thanx Gena , will try it.
|
|
|
|
|
