Field conditional to date

[NogueirAds_Ads]

This should be easy but i am not succeeding in getting it done.

I have a field named “month” and i want it to change according to a date field. If the date is in October i want that field to have the word “October”. I have it as a single select field but i would like it to be automatic. How can i do this? Be it an automation or function or zapier or whatever.

Thanks in advance.

[Kamille_Parks]

Either convert the single select into a formula field, or create a new formula field, with this formula:

DATETIME_FORMAT({Date Field}, "MMMM")

If you want to keep your original single select field, use an Automation to copy the value of the formula field into the single select whenever the value of the formula field changes. This is going to eat into your monthly allotment of automation runs so this may not be sustainable without using a script to reduce the number of times the automation should run.