Exclude partial month from list box

[Anonymous]

Hi,

I'm trying to create a list box that excludes partial months. The partial month will always be newest data, and I want to keep it in the load for other purposes.

For example, the list box shouldn't show Apr-2024 if the latest data goes up to 8th April 2024.

Many thanks

[marcus_sommer]

You may prepare such field within the calendar, maybe with something:

if(today() - ThresholdValue < monthstart(today()), MyDateField, null()) as MyDateField2