Listbox to show maximum date in each month selection

[Jesh19]

Hi All,

I have a requirement where my Reporting Date should pick Max(Reporting Date) for each month selection.

By default, my app shows Max(Reporting Date), but when I select any specific month, my selections are going off on Reporting Date.

NOTE: Reporting Date is shown using Calendar Object.

For ex: When I open my application, it would be defaulted to Max(Reporting Date) i.e., 15/11/2020, but when I select Oct in Month, I don't see any value selected in calendar object, it should show 31/10/2020

For Sep, 30/09/2020...Aug, 31/8/2020

Can someone please help me with the issue.

Thanking in Advance.

Jesh

[MayilVahanan · Accepted solution]

HI @Jesh19 

You need to assign trigger for that in Document properties -> Triggers

Change the date field and provide the date format based on ur data.

[Jesh19]

Thanks for your help @MayilVahanan  😊