How to do date ranges?

Hi :smiley:!
I have a question of dates expressions.
I have the next condition:
UX date range condition

I have a lot of dates, but each date has the same condition, it function if [Fecha Cierre] = Today, but i need a range of dates for example:

[Fecha Cierre]= 12/07/2020

[Fecha Cierre]-1= 11/07/2020
[Fecha Cierre]-2= 10/07/2020
[Fecha Cierre]-3= 09/07/2020

How i do a range with [Fecha Cierre]-1, [Fecha Cierre]-2, [Fecha Cierre]-3 in one variable?

(This is for a range of dates to notify emergencies)

Try with this:

IN(
    [Fecha Cierre],
    {TODAY()-3 , TODAY()-2 , TODAY()-1 , TODAY() , TODAY()+1 , TODAY()+2 , TODAY()+3}
)

You can implement the List parameter of the IN() expression as per your query range.

1 Like

If i create a virtual column with a typedata “date”

[Fecha Cierre]= 12/07/2020

Range of dates that i want to take:
[Fecha Cierre]-1= 11/07/2020
[Fecha Cierre]-2= 10/07/2020
[Fecha Cierre]-3= 09/07/2020

How i take the date range?

Clearly, we don’t understand what you mean by “how do I take a date range” or “how i do a range”, or you don’t understand the advice you’re being given. Please provide a lot more detail about what you want.