Skip to Content
Former Member
Nov 01, 2009 at 05:55 PM

Crystal Reports Date Function Problem


I am having a problem with my record selection based on a date range. I am using the formula:

{Record_Selection_csv.Event Time} <= {?RecordSelectionFinishDate} and {Record_Selection_csv.Event Time} >= {?RecordSelectionStartDate}

Where Record_Selection_csv.Event Time is a date field in my database in the format "09/08/2009 16:31:13" Day/Month/Year/ HOUR:MIN:SEC. I believe I am missing some of the selected records because if I select a finish date 09/08/2009 I will only retrieve records who's date is less then or equal to 09/08/2009 00:00:00 and will not contain dates 09/08/2009:24:59:59.