How can we help?

New post
0

How to display a range of dates from today until today + 2weeks?

Avatar
Jochem Cuppen
None
Follow

Hello,

I am trying to display a list of all events in the upcoming two weeks. My data looks like this:

  • 09/01/2020 Event A
  • 27/01/2020 Event B
  • 29/01/2020 Event C
  • 03/05/2020 Event D

I would like to filter on all events from TODAY until TODAY + 2 weeks. In the example it should only show Event B and C. How to best filter the list of dates? I've tried using the SELECT formula with such a formula:

I've also tried user input control, but I cannot seem to use relative dates in the default value fields.

Any other thoughts?

Kind regards,

Jochem

 

Date Votes

1 comment

  • 0
    Avatar
    Janice Janczyn

    Hi Jochem,

    You are on the right track. Note that uppercase 'M' represents months while lowercase 'm' represents minutes. The 1st parameter in the BETWEEN function are the dates you want to compare and the 2nd and 3rd parameters are the start and end dates, respectively, that you are checking for. So the 2nd parameter is TODAY and the 3rd parameter is DATE_ADD( TODAY(), week, 2 ) which is today plus 2 weeks.

         SELECT( @Date, BETWEEN( DATE( @Date, "dd/MM/yyyy" ), TODAY(), DATE_ADD( TODAY(), week, 2 ) ) )

    I hope this helps!

    Thank you,
                Janice

Please sign in to leave a comment.