Hi all,
I need to find a date period. For example to find all birth dates from
2008-01-02 to 2008-01-05 including start and end date. Using the
performFind service and the following field in the UI:
<field name="birthDate" title="Time Period">
<date-find type="date"/>
</field>
The problem is the following.
The entity field type is date (java.sql.Date). For example 2008-01-02.
The start period date also is 2008-01-02. Then I need to compare 2
equals value (2008-01-02 00:00:00.000). But I don't see such a operator
in the performFind. If I am using "Greater Than From Day Start" the
entityOperator is "GREATER_THAN" and that exclude the start date
(2008-01-02). Thus I found only birth dates after 2008-01-02, but
without in 2008-01-02.
For the end date I am using "Up Thru Date" and it's OK.
One of decision could be a new options for the "GREATER_THAN_EQUAL_TO"
entity operator. For example "Greater Than Equal To" and "Greater Than
Equal To From Day Start".
Any thought would be appreciated! And then as soon as possible I can
create a patch.
Thanks, Stanimir!
