Click here to Skip to main content
15,921,577 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
I have a column in tblRegPatient name Date and its DataType is "Date".
and I am trying to filter the data in crystal report by Date, while writting the formula of
If {tblRegPatient.Date} >= {?start_date} and {tblRegPatient.Date} <={?end_date} then true
there is error saying "A string is required here".
The type of start_date and end_date is Date but when I Browse Data of column Date in Field Explorer it is "String" but its datatype is "Date" in my tblRegPatient.. It is strange.. Please help me. Thanks!

What I have tried:

If {tblRegPatient.Date} >= {?start_date} and {tblRegPatient.Date} <={?end_date} then true
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900