Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You may prepare such field within the calendar, maybe with something:
if(today() - ThresholdValue < monthstart(today()), MyDateField, null()) as MyDateField2