Peek date?

[johnan]

Hi, 

I have at table with dates.

I want to only have the next post after :
Where Date= Today() + Next day

2020-03-13 (I want 2020-03-13 and 2020-03-16)
2020-03-16 (I want 2020-03-16 and 2020-03-17)
2020-03-17 (I want 2020-03-17 and 2020-03-20)
2020-03-20

I forgot, but i think peek?

[digichap28 · Accepted solution]

I would first order the table, later use peek to get the previous date and finally reorder it using ASC.

1)Loading the data

2020-03-13 
2020-03-16 
2020-03-17 
2020-03-20

2) Ordering DESC

2020-03-20 
2020-03-17 
2020-03-16 
2020-03-13

3) Using PEEK

2020-03-20 
2020-03-17 - 2020-03-20
2020-03-16 - 2020-03-17
2020-03-13 - 2020-03-16

4) Ordering ASC

2020-03-13 - 2020-03-16 
2020-03-16 - 2020-03-17
2020-03-17 - 2020-03-20
2020-03-20

I hope you get the idea

Best regards

[johnan]

Yes, thanx mate 🙂