tamara
Posts: 26
|
| Posted: 11/14/2005, 10:13 AM |
|
I am trying to set up a search that will return results between two dates. I just can't seem to get it right. Any suggestions?
|
 |
 |
peterr
Posts: 5971
|
| Posted: 11/14/2005, 10:21 AM |
|
Please see:
http://forums.codecharge.com/posts.php?post_id=44758
http://forums.codecharge.com/posts.php?post_id=51382
http://forums.codecharge.com/search.php?s_keyword=searc...m[]=6&s_period=
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
tamara
Posts: 26
|
| Posted: 11/15/2005, 4:39 AM |
|
Thank you. This is what I have been doing. I am afraid the problem may be that my data type is NVARCHAR and of course, I can't change it. Is there a work around for this?
|
|
|
|
Edd
Posts: 547
|
| Posted: 11/15/2005, 1:46 PM |
|
If your dates are stored as NVARCHAR's then you can convert the NVARCHAR's to dates uing SQL functions such as CAST or Convert.
! would suggest your lookup either becomes a store procedure OR you convert the table lookup to SQL then add the convert / cast statements in SQL manually.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
tamara
Posts: 26
|
| Posted: 11/15/2005, 3:53 PM |
|
Thanks Edd: I am pretty new to SQL so most of this is new to me but I am going to look this up and try your advise.
|
|
|
|
