Button - Selecting the dates in the past 30 days

[dranjbar]

Hi all,

I'm trying to make a button which selects the date range of the past 30 days.

Currently my code for selecting todays date works - =date(today())

My code for selecting the date 30 days ago works - =date(today()-30)

Although I cant seem to get the code right for the selection of all the dates in the last 30 days.

I've been reading the forums and I can see code like this (and variations of this) - ='>=' & date(today()) & '<=' & date(today()-30)

But it doesn't seem to work in my occasion (It seems that I cant get the greater than or less than signs to work with my button).

This is where I am inputting my data.

Is anyone able to help me with this?

Thanks in advanced!

[MayilVahanan]

Hi @dranjbar 

Try like below

='>='&Date(Today()-30,'YYYY-MM-DD')&'<='&Date(Today(), 'YYYY-MM-DD')

Change the date format based on ur date (YYYY-MM-DD)

[dranjbar]

Hi @MayilVahanan 

Unfortunately this is still not working, I can select a date fine, I just cant select a range of dates.

[MayilVahanan]

Hi @dranjbar 

Can you send a sample file

[saimahasan]

What is your date format?

[dranjbar]

Hi @saimahasan 

My date format is DD/MM/YYYY

[EliGohar]

@dranjbar 

Make sure you select the following action:

Eli.