[WebERP-developers] BOM effective dates mismatch

[Vitaly S. <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