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.
- Hi dscheikey - thanks for your quick review of the data. Yes this seems to follow what I need. True or False there has been equal to or greater than 30 days between the above and below dates. I have ALOT more data in this format. Does it work to drag this below. I don't want to fall foul of assuming it's worked OK. See V2 attached.
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?
