Forum Discussion

cxbrasch's avatar
cxbrasch
Registered
28 days ago

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?

 

 

No RepliesBe the first to reply