Hello friends in my app I calculate the inventory by adding the entries and subtracting the outputs to an initial inventory that has a date (UPD). This is compared with the movements of inputs and outputs to know which ones should be considered, those after the date that was taken on inventory โฆ in the formula that simplifies for the demonstration! I found the following error !!
consider only the comparison with the date (day and month) but ignore the time !
the image that annex is very clear โฆ and this is the โexampleโ formula
IF ([PRODUCT INV?], SELECT (DETAIL [UPD], AND ([ART ID] = โDREAM CUCUMBERโ, [UPD]> DATE (โ06/23/2018 13:50:22โ))), { CSA, FRE, WSA})
I have been using this formula for months and since this week I have not done it well! DATE> = DATE_INV
Please help !
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |