I am trying to have a column to show me the next date of a given month and day.

For example, I have a column that has contract renewal dates. These would be

Jan 1

Aug 1

September 1

December 1

Etc …

I would like the column next to it to figure out the next date based on todays date. If today is August 28, These values would be:

Jan 1, 2025

Aug 1, 2025

Sept 1, 2024

December 1, 2024

Is this possible? I've tried researching but can't find this specific answer. Thanks in advance!

Find more posts tagged with

Accepted answers

All comments

Matt Lynn ACT

@Herculean You'll need to create one or more helper columns to convert this.

For the Month you'll have a series of if() statements (12 in total) that say if( Jan, 1, if feb, 2 etc. Then you can use a =date() function to pull the text from the right() side of the string all in all ending up with an actual date column created from the string.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.