Importance: Normal To get all dates, you'd need to populate the from and to date parameters with dates outside the range of dates you expect in the data. Note that this technique will not work if you use .NULL. instead of {} for empty dates, which might be the case in SQL Server date fields. Rob | | | | >Hi! | > | >Regards from Mexico! | > | >I have two questions: | > | >1.- By default the Ctextbox class, eliminate the left spaces, | how can I do for not? | > | >2.- I have a parameterized view, with 'LIKE' comparison, so I | can put '%' in the value's parameters. But now, I have a | parameter type DATE, so how can I do to find every date? | > | >Thanks a lot! | | Hola Gavilán, | | I don't understand your first question. For the second, you can | use dates easily in view parameters, like this: | BETWEEN (dEcheance, ?vp_dBeg, ?vp_dEnd) or dEcheance < ?vp_dBeg. | Simply don't forget to define your parameters as DATE type. | | José |