Previous Month formula

I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is previous MTD. If the Create Date is the previous month, then check a box. If the Create Date is older than previous month, don't check the box or uncheck the box if it was already check. Below is my formula for the MTD

=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = MONTH(TODAY())), 1)

I'm sure it is an easy formula but I can't figure it out.

Find more posts tagged with

Formulas

Accepted answers

Nick Korna

Hi @Carol-Anne Cerbone,

If you're just wanting the month to compare to last (e.g. July today vs. June last), then this will do what you're after:

=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = (MONTH(TODAY())) - 1), 1)

Hope this helps! 😊

All comments

Nick Korna

Hi @Carol-Anne Cerbone,

If you're just wanting the month to compare to last (e.g. July today vs. June last), then this will do what you're after:

=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = (MONTH(TODAY())) - 1), 1)

Hope this helps! 😊

Carol-Anne Cerbone

@Nick Korna - that did it. I have the 1 in the wrong place. I had it in the TODAY(-1). Thank you for your help and I hope you have a great day!

Nick Korna

You're more than welcome; happy to have helped!

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.