hi all
 im using the following querry for crystal report
rr.SQLQuery = "select * from Table where Format(DateField , 'yyyy/mm/dd' ) >= format ( '" & fromdt & "','yyyy/mm/dd' ) and Format(DateField ,'yyyy/mm/dd') <= format ( '" & todt & "','yyyy/mm/dd' )"

my datefield in database is text type

The pblm is , while selecting the date ranges like 2007/01/31 to 2007/02/01 im not getting the report details for some other ranges
im getting results , tried a few things but didnt clicked

Please help
Renjith

hi there..

and you have data for that date range?? you are only showing the records with date 2007/02/01 with that query..

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

HI

  Im letting the user to select a date range

Thanks
renjith

ok.. that's ok... but the query is failing??? do you have data to show for that specific query??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

yes offcourse im getting the result if i select the rang 2007/01/31 to 2007/02/06

I 'm not following you.. can you explain better where is your problem then???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

you should make date from ur text field by using date, left, right and mid (text related) functions.

first of all separate the day month and year from text field and than use date function to make it as date

you can use date format of YYYYMMDD format. it is easy to compare range of date by using this format..

regards
bhavesh

Nothing

hi Gonzalo
  my database has enough records , date field in table is of text type , while im generating
report using date range some range gives me exact result but some not like above said ranges

Thanks
renjith

hi bhavesh
   can u give me some example code
Thanks
Renjith

hi bhavesh
  thnks using reply i sorted the pblm
thnks very much
Renjith