Forum Discussion

Wadda7AboUdai's avatar
Wadda7AboUdai
Icon for Helper I rankHelper I
2 years ago

calculate days count between 2 dates

Hello Everyone  I want to calculate days starts with item purchese date to item transfer date , items can be more than ones in the table it means can be purchesd more than ones and for all branches ...
Need Hepl
Wadda7AboUdai's avatar
Wadda7AboUdai
Icon for Helper I rankHelper I
2 years ago

tamerj1  Yes, that is correct. Could the method be to search for the first purchase transaction and then calculate the date Different to transfer order  closest to the purchase date?

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Wadda7AboUdai 

That won't work. In your original post example (item B, transaction number 3) has to be skipped as it hasn't been transferred to branch. The closest transfer date to this transaction is the one that belong to B-4. To identify that this transaction has not been transferred we need to do more work. 

This is very similar to attendance data where you have multiple punch in and punch out in a given date. It's not that it is not possible but it is a bit complicated and probably requires creating a new calculated table.

Best option is to have this identified from the source or at least calculated easier with SQL.