Re: [WebERP-developers] BOM effective dates mismatch

[gilberto d. s. a. <gs...@gm...>]

Hi. Please could you describe (if possible) what scripts you are talking
(tools like diff or others similar). Thanks for your time.

2015-01-21 16:48 GMT-02:00 Vitaly Shevkunov <vsh...@so...>:

> Hello all,
>
> I just noticed, that there is a discrepancy in how different scrips
> access the BOM table. Some of them do this
>
>              AND bom.effectiveafter < '" . Date('Y-m-d') . "'
>              AND (bom.effectiveto > '" . Date('Y-m-d') . "'
>               OR bom.effectiveto='0000-00-00')";
>
> Others have
> AND bom.effectiveto >= '" . date('Y-m-d') . "'
>                AND bom.effectiveafter <= '" . date('Y-m-d') . "'";
>
> And yet others do not check effective dates at all.
>
> I would like to fix this, but I am not sure if I am supposed to use '>'
> or '>='.
>
> Thanks,
>
> Vitaly
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil