topic Re: Button for YearToDate selection in App Development

Button for YearToDate selection

MCmiranda — Sat, 16 Nov 2024 01:08:59 GMT

Hello smarties,

I want to make a button for the selection of the last 12 months and a selection of the last month.

I find a variety of functions, but don't know which one to use.. Anybody can set me up with this?

I've set Action:

Select value in a field -> field -> name is 'Date Check'
Now I have to put in a value.. To get the last 12 months from today.

GaryGiles — Mon, 09 Nov 2020 16:36:54 GMT

Try this:

=Concat({1<[Date Check]={"<$(=Today())>$(=AddMonths(Today(),-12))"}>} [Date Check],';')

QFabian — Mon, 09 Nov 2020 16:34:05 GMT

>=addmonths(yourdate, -12) <= yourdate

MCmiranda — Mon, 09 Nov 2020 17:53:06 GMT

Thank you, this is awesome!

MCmiranda — Mon, 09 Nov 2020 19:54:53 GMT

Hi Gary,

I believed I could figure the code for the selection of this month myself, for the other button.. But I can't

I tried:

=Month(Today())

=AddMonths(Today(),1)