End user report - Date query without time portion

rbuser

We have a Delphi application and that uses the report explorer in RB
Enterprise 10.06. We need to create an end user report that prompts the
user to enter the "Date_Made" that they want to search for. The problem
is that the Date_Made field is a DateTime, so entering 05/01/2013 in the
search criteria won't work since the field has time in it as well. What
is the best way to deal with this?

nicocizik

Hi David,

ReportBuilder converts all dates into TDateTime types using the Delphi
StrToDateTime routine. The way this conversion takes place can be
manually controlled. See the following article for more information
about using dates and times with DADE.

http://www.digital-metaphors.com/rbWiki/DADE/Fundamentals/Date_Formatting

rbuser

Thanks Nico. I was able to fix the problem.