Date to Month Single Select

1099 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


I believe what I'm asking could be a fairly simple fix but been trying to figure out and see if anyone has a formula for this. I created a Task + time tracking sheet for my employees. I'm trying to see if when I put the due date for instance if something is due 04/04/2023 I'd like to see if there's a formula or automation to make a single select field as well to put the month in. So in this instance, the field would be "April 2024" 

Please let me know if anyone has a solution for this. Additionally, if anyone has any great time tracking/tasks ideas to add to my base please let me know!

1 Reply 1
18 - Pluto
18 - Pluto

Hmm, try creating a formula field with `DATETIME_FORMAT({Date}, "MMMM YYYY")` to get the format you want, and then use an automation to paste the value from that formula field into your single select field.  Might need to add a `DATEADD()` in there if you want it to be a year later

Your automation trigger would be "When record updated" and you could point it at the date field directly