Filter through range of dates excluding year

paulmagaling
Tera Contributor

3 hours ago

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

 

0 Helpfuls
  • 38 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron

2 hours ago

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.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls