topic Re: Next and Previous date based on current date in App Development

Next and Previous date based on current date

Naushad07 — Sat, 16 Nov 2024 19:18:39 GMT

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 — Tue, 14 Jan 2020 09:49:43 GMT

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