Next and Previous date based on current date

[Naushad07]

Hi,

Date

12/27/19

1/15/20

2/13/20

I need to find the next date and the previous date based on today's date in this table.

Ex: Today 1/13/20 then Next date- 1/15/20 Previous date-12/27/19

How can I do that in Qlik Sense?

[Stoyan_Terziev · Accepted solution]

Hi,

You can use a set expression like so for previous date:

Max({<Date = {"<=$(=Date(Today()))"}>} Date)

 And like so for the next:

Min({<Date = {">$(=Date(Today()))"}>} Date)

Remember to be mindful of date formats!

I hope that helps!

Regards,
Stoyan