Forum Discussion
Time between date look up and return value
Hikimbirch2,
good that you asked. By your change at the beginning of the line it would not have worked. In addition, there was a change in the structure of the data. The line below Trip # was no longer empty but already contained the first record. Therefore I changed the structure now completely and worked with filters. But you also got a summary of the data > 30 days. I hope you like it.
Hi kimbirch2,
none of your trips has lasted more than 30 days. 26 days is the maximum. Please look at my table with a suggested solution. Does this correspond to your question? Possibly I did not understand something correctly.
I have left all the auxiliary columns so that you can easily understand the approach. I hope it fits like this.
Hikimbirch2,
good that you asked. By your change at the beginning of the line it would not have worked. In addition, there was a change in the structure of the data. The line below Trip # was no longer empty but already contained the first record. Therefore I changed the structure now completely and worked with filters. But you also got a summary of the data > 30 days. I hope you like it.
- HI - sorry I've realised an error in how it's being calculated. The dates need to refer duration of dates within each trip and between the previous and the next.
If you review you'll see that the rows are actually a repeat of annual time periods running 30 June 2021 to 30 June 2022. Then repeats in this annual cycle multiple times.
There's a number of 30 day period between trips which I need to flag. Any thoughts on this? This is perfect! Thank you so much! 🙂 Have a great day.