Is there a reason CustomTimePeriod Date types are not Timestamp?

[Christian Carlow-OFBizzer]

Does anyone know why CustomTimePeriod fromDate and thruDate are of type
date instead of timestamp?  Because the fields are of type date, it
causes issues when joining the it for date comparison for view-entities.

For example:
     <view-entity entity-name="OrderHeaderAndCustomTimePeriod"
package-name="">
         <member-entity entity-alias="OH" entity-name="OrderHeader"/>
         <member-entity entity-alias="CTP" entity-name="CustomTimePeriod"/>
         <alias-all entity-alias="OH"/>
         <alias-all entity-alias="CTP"/>
         <entity-condition>
             <condition-expr field-name="orderDate" entity-alias="OH"
operator="greater-equals" rel-field-name="fromDate" rel-entity-alias="CTP"/>
             <condition-expr field-name="orderDate" entity-alias="OH"
operator="less-equals" rel-field-name="thruDate" rel-entity-alias="CTP"/>
         </entity-condition>
     </view-entity>

The problem occurs when the OrderHeader.orderDate falls on the last day
of the CustomTimePeriod.thruDate because the CustomTimePeriod.thruDate
is converted to Timestamp but with time 00:00:00.000.  Changing the
CustomTimePeriod Date types to Timestamp seems like the easiest but I'm
sure Accounting code will have to be changed.

[Jacopo Cappellato-3]

Hi Christian,

this is a known issue and there is already a ticket with some comments in it:

https://issues.apache.org/jira/browse/OFBIZ-5740

Jacopo

On Sep 19, 2014, at 11:16 PM, Christian Carlow <[hidden email]> wrote:

> Does anyone know why CustomTimePeriod fromDate and thruDate are of type date instead of timestamp?  Because the fields are of type date, it causes issues when joining the it for date comparison for view-entities.
>
> For example:
>    <view-entity entity-name="OrderHeaderAndCustomTimePeriod" package-name="">
>        <member-entity entity-alias="OH" entity-name="OrderHeader"/>
>        <member-entity entity-alias="CTP" entity-name="CustomTimePeriod"/>
>        <alias-all entity-alias="OH"/>
>        <alias-all entity-alias="CTP"/>
>        <entity-condition>
>            <condition-expr field-name="orderDate" entity-alias="OH" operator="greater-equals" rel-field-name="fromDate" rel-entity-alias="CTP"/>
>            <condition-expr field-name="orderDate" entity-alias="OH" operator="less-equals" rel-field-name="thruDate" rel-entity-alias="CTP"/>
>        </entity-condition>
>    </view-entity>
>
> The problem occurs when the OrderHeader.orderDate falls on the last day of the CustomTimePeriod.thruDate because the CustomTimePeriod.thruDate is converted to Timestamp but with time 00:00:00.000.  Changing the CustomTimePeriod Date types to Timestamp seems like the easiest but I'm sure Accounting code will have to be changed.