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.
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?- Hi dscheikey - have attached v3.
This is super manual but hopefully show you what I mean. The data runs in annual periods from 30 June 2021 to 30 June 2022.
Within these date ranges I need to know if there are any period equal to or greater than 30days between dates including the start and end date.
What's probably needed first is to split the data into annual period 1, annual period 2 etc?
Hopefully this makes sense!
This is perfect! Thank you so much! 🙂 Have a great day.