We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Filter through range of dates excluding year

paulmagaling
Tera Contributor

Is there a way to filter a date field within a specific range without including the year?

For example, I only need to filter the end date in the range of October 1 to March 31 (10-01 to 03-31) instead of 2025-10-01 to 2026-03-31.

paulmagaling_0-1768900582700.png

 

2 REPLIES 2

ManishS14752344
Tera Contributor

Hi,

 

Exactly where are your trying to  use this filter?

Dr Atul G- LNG
Tera Patron

Hi @paulmagaling 

 

This is an out-of-the-box (OOTB) approach, so you have two options:

  • Create or store the year separately at the record level.

  • Then create a new filter based only on the year.

However, this will create technical debt. I recommend using the approach provided by the platform and educating users accordingly.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG

****************************************************************************************************************