topic Date range for years in App Development

Date range for years

aatish12345 — Wed, 22 Dec 2021 09:44:53 GMT

Hello Everyone,

I have a date field which consists of dates from 2020-01-01 to 2021-08-31

I want to create a new field which will show below values when used in filter

>2021-08-31

2021

2020

<2020-01-01

I tried it using if statement but not able to achieve the above expected results..

Any help would be really appreciated!

Aatish

Vegar — Wed, 22 Dec 2021 10:33:15 GMT

Try an IF statement like this

If(DateField>=makedate(2021,9),'>2021-08-31', If(Year(DateField)=2021,'2021', if(Year(DateField)=2020,'2020','<2020-01-01')))

aatish12345 — Wed, 22 Dec 2021 11:09:53 GMT

Hi Vegar,

Thanks for the reply!

Actually I want to make a code dynamic.

The solution you've provided includes hardcoding.

Aatish

Vegar — Wed, 22 Dec 2021 11:22:52 GMT

Then you would need to replace the har coded parts with some kind of logic.

Alternatively you could look into creating an interval table and then apply your groups using interval match.