cxbrasch
28 days agoRegistered
Formula Text field populating based on date range
I am working on a task scheduler for my team that would automate the task assignments. Tasks are based on season. How can I automate the Season field using date ranges that exclude a year. As of now this is the formula I use:
If([Date Assigned] > Date(2024,10,15) and [Date Assigned] < Date(2024,12,31) ,"Aep",
If ([Date Assigned] > Date(2025,1,1) and [Date Assigned] < Date(2025,2,28) ,"Aep","Non-AEP"))
This gets what I need - this year. But if we use this going forward I will need to go in and change the dates to adapt for next year. How would Month(ToDate(Date Assigned)) or something similar be used to accomplish this goal regardless of year?