Pull month and year

Is there a way to pull the date and year from one column to another? I am currently using the following formula to pull the year out of the Report date column.

Report Column. Mandated Date Column

10/8/2020 =IFERROR(YEAR([Validation Report IA Date]@row) + 1, "")

I would like the "Mandated Date Column" to display the month/year (a year out). Is there a way to do this?

Any help would be appreciated.

Thanks, Peggy

Find more posts tagged with

Accepted answers

MCorbin

@Peggy P

Here you go:

=IFERROR(IF(LEN(MONTH([Report Date]@row)) = 1, "0" + MONTH([Report Date]@row), MONTH([Report Date]@row)) + "/" + (YEAR([Report Date]@row) + 1), "")

All comments

MCorbin

=(YEAR([Report Date]@row) + 1) + "/" + IF(LEN(MONTH([Report Date]@row)) = 1, "0" + MONTH([Report Date]@row), MONTH([Report Date]@row))

Peggy Parchert

Thank you - one more question:

I want it to read "MM/YYYY" - I tried moving the (YEAR([Report Date]@row) + 1) to the end but I'm getting a syntax error now. Is this not a possible format? I don't see an option like this in the dropdown for dates and I don't have the "Mandated Date Column" as a Date type - should it be?

Peggy Parchert

@MCorbin - is it not possible to have a format of MM/YYYY for this? I've switched the formula around but it keeps giving me an error message.

Mandated Date Column is a text/number type (since I don't see MM/YYYY as a date option)

=IFERROR(IF(LEN(MONTH([Latest IA Validation Date]@row)) = 1, "0" + MONTH([Latest IA Validation Date]@row), MONTH([Latest IA Validation Date]@row)) + “/“ + IF(YEAR([Latest IA Validation Date]@row) + 1)), "")

I can get each part of this formula to work but I can't seem to make it work together.

MCorbin

@Peggy P

Here you go:

=IFERROR(IF(LEN(MONTH([Report Date]@row)) = 1, "0" + MONTH([Report Date]@row), MONTH([Report Date]@row)) + "/" + (YEAR([Report Date]@row) + 1), "")

Peggy Parchert

@MCorbin - thank you very much for the help!

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.