Select last 31 days with action button

[pepe2209]

Hello,

I thought this would be easy but I can't get it to work:

I have the variable 'Startdate' and with one click on an action button i want to select only the dates within the last 31 days.

I tried the action select in field with field 'Startdate' and value: =if(Startdate>=today()-31, '*')

but this does not work.

The only other way i can think of is creating a new field in the script 'Lastmonth' with 1 for each 'Startdate' within the last month. But i rather not add another variable to an already large dataset and application.

is it possible to do this without a extra field?

your help would be much appreciated.

Regards

Peter

[Nicole-Smith · Accepted solution]

Select in Field: Startdate with the expression:

='>=' & date(today()-31) & '<=' & today()

[Michiel_QV_Fan]

Peter,

Do you need the last 31 days prior to the selected date, or, do you need the current month or do you need the previous month?

[pepe2209]

@Nicole Thanks this works!

[pepe2209]

Hello

I actually want both, the last 31 days prior to today, and the previous month. The first one is already fixed thanks to Nicole. Now I'm trying to figure out the second one

[pepe2209]

Ok now I use  this:

='>=' & MonthStart(today(),-1) & '<=' & MonthEnd(today(),-1)

for selecting all dates in the previous month