topic Re: Button - Selecting the dates in the past 30 days in App Development

Button - Selecting the dates in the past 30 days

dranjbar — Mon, 20 Dec 2021 21:08:46 GMT

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 — Tue, 17 Nov 2020 03:52:13 GMT

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 — Tue, 17 Nov 2020 03:55:38 GMT

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

MayilVahanan — Tue, 17 Nov 2020 04:02:43 GMT

Can you send a sample file

saimahasan — Tue, 17 Nov 2020 04:55:35 GMT

What is your date format?

dranjbar — Tue, 17 Nov 2020 05:19:39 GMT

My date format is DD/MM/YYYY

EliGohar — Tue, 02 Mar 2021 15:06:24 GMT

Make sure you select the following action:

Eli.