Hello friends in my app I calculate the inven...

(Lavanderias El Sol) #1

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 !

(Suvrutt Gurjar) #2

Hi @Efren,May I request you to change the part of expression


[UPD]> DATE (“06/23/2018 13:50:22”)

TO [UPD]> DATETIME (“06/23/2018 13:50:22”)