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 !