Single Select Field Triggering a Date

[Mary_Carroll-Co]

I’d like to have a single select field trigger a date field and am asking the community for help with the formula.

My goal is to have a single select field with the following options: now - this month, next month, future, next, etc. My goal is to have a date auto-populate based on the dropdown selection that dates the item at the end of the next month.

For instance, if today were January 5, 2050 and I have an item marked as “Now - this month”, I want a date field to auto-populate with January 31, 2050. If I changed the single select to “Next Month”, the date field would automatically update to read February 28, 2050.

Does anyone know how I do this?
Thank you!

[TheTimeSavingCo]

Hey Mary, I’ve set something up for you here. To view the formula in use, duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.

The idea is to create a Last modified time field and make it track the single select field in question

We then create a formula field that will output dates that you require based on the date in the Last modified time field

I got the formula to get the last day of the month from the following post by @kuovonne, and an in-depth explanation of how it works can be found there as well

Calculate 1st and last day of the month / Get the average amount for each day of the month? Dates and timezones

Here’s a pair of formulas. The first day of the month has the same month and year as the given date, but the day is “1”. DATETIME_PARSE(YEAR({Date}) & "-" & MONTH({Date}) & "-01", 'YYYY-MM-DD') The last day of the month is one month later than the first day of the month, less one day. Note that this formula references the field with the previous formula: DATEADD(DATEADD({First Day of Month}, 1, 'month'), -1, 'day') The first and last days of the quarter are easier, because they always have …

[Mary_Carroll-Co]

Adam,
Thanks so much for sending this along. I will give it a try now and let you know how it goes.
I appreciate you responding so quickly.