Trying to return 3 months prior to Date Column

Hello,

I am trying to make a column to return dates 3 month before the date in another column. Essentially going to be notifying teams 3 months before something expires.

I have a column for the dates. It is set to "date" and i'm using this formula in a helper column

=DATE(YEAR(DATE@row ), MONTH(DATE@row ) - 3, DAY(DATE@row ))

AI is telling me this is correct but it keeps giving me Invalid Column Type. I've tried different date patterns with no luck. Any suggestions?

Find more posts tagged with

Accepted answers

Corey W.

@Michelle Patrick Is the column with the function you listed also a date type column?

All comments

Corey W.

@Michelle Patrick Is the column with the function you listed also a date type column?

Michelle Patrick

OMG No! THANK YOU! 🤦‍♀️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.