Forum Discussion
Helper Icalculate days count between 2 dates
Community ChampionExcept it is not the same thing. Voucher defines each single transaction. What is required is a column that groups the transactions that belong to each cycle. If such column does not exist then it has to be created. If not coming from the source then I would say that won't be an easy job.
Helper Itamerj1 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
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.