topic Re: Need help for dynamic default bookmark to set as Previous Month in App Development

Need help for dynamic default bookmark to set as Previous Month

Nandita27 — Fri, 15 Nov 2024 21:34:37 GMT

Hi Team,

I wanted to set Dynamic default bookmark as previous month compare to system date but my expression is not working

=J&J Calendar Month = Date(Addmonths(Today(), -1), 'MMMM') where J&J Calendar Month is my field name

Can anyone help me on this.

Thanks,

Regards,

Nandita

Re: Need help for dynamic default bookmark to set as Previous Month

Satish251 — Mon, 17 Jul 2023 05:52:53 GMT

Hello @Nandita27,

Try this,

=Num([J&J Calendar Month])=num(month(date(addmonths(today(),-1),'DD/MM/YYYY')))

Note: Change Date format if it is not same in your date field.

Re: Need help for dynamic default bookmark to set as Previous Month

CezarioAbrantes — Mon, 17 Jul 2023 12:34:49 GMT

Hi Nandita,

You can try this:

=[J&J Calendar Month]=Month(MonthStart(Today()-1))

AddMonths would return 17/06/2023, while MonthStart returns 01/06/2023 and it is more useful for month comparisons.

Regards

Cezário

Re: Need help for dynamic default bookmark to set as Previous Month

Nandita27 — Mon, 17 Jul 2023 16:59:50 GMT

Thank you Satish it is working for me only thing I had to change it to like this since my Month value was in full name like January, February etc.

=Num(Month(Date#([J&J Calendar Month],'MMMM'))=num(month(date(addmonths(today(),-1),'DD/MM/YYYY')))

Thanks a lot 🙂

Re: Need help for dynamic default bookmark to set as Previous Month

Nandita27 — Mon, 17 Jul 2023 17:07:41 GMT

Thanks a lot Cezario for your suggestion. Since my month value was in full name I had to change it as below and it is working for me

=Date(MonthStart(Today(),-1),'MMMM')

Anyway later my customer changed the requirement like Dynamically need to select from January to Last Month(i.e as of today till June) instead of only selecting June so I have implemented as below

=Num(Month(Date#([J&J Calendar Month],'MMMM'))<=num(month(date(addmonths(today(),-1),'MM/DD/YYYY')))

Thanks again. Appreciating your help!!

Regards,

Nandita