Hi, I want to do like this table
"temp2" Lineitem searches the days from now to next temp1.
Is there any function like this?
@hyudolee There is no native function that does this, but you can achieve this one with some simple staging.
Essentially I am looking for when the next time is that X is being checked. Once I find that, I can do the math on the difference between the day and the next day that is checked.
Hope this helps!Jason
That's a good idea! Thanks!