Help

Date to Month Single Select

1001 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Cristina_Garcia
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello!

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
TheTimeSavingCo
17 - Neptune
17 - Neptune

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