Re: [WebERP-developers] BOM effective dates mismatch

[Phil D. <ph...@lo...>]

All scripts should be checking the effectivity dates.

effectiveafter <= '" . date('Y-m-d') . "' AND effectiveto > '" .  
date('Y-m-d') . "'

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/01/15 07:48, Vitaly Shevkunov wrote:
> te('Y-m-dHello 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
>