# How to do date ranges?

Hi !
I have a question of dates expressions.
I have the next 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.