Request for Help Returning Months Earlier Than Selected Period

Q&A
,
1

Hi, I need to return all months that occur before the period selected in the filter (for example, November 2025). Could you please help me achieve this?

2

Hi @Narayana1

Create a date parameter for users to select a reference period (e.g., November 2025), then use a calculated field with truncDate to identify and return all months before that period. Apply to the parameter to date field as a filter to show prior months exclusively. Please refer the following images for reference.

image
image642Ă—648 26.4 KB

image
image277Ă—738 26.2 KB

1 Like
3

Hi @Narayana1,

Hope everything is well with you! Just checking back in since this thread hasn’t received a response in a while. Was Xclipse’s reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!

Thanks!

4

Hi @Narayana1,

Since we haven’t received any further updates from you, I’ll mark this post as “Solution.” If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you!