nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to edit a formula to pull data within a specific date range?

Not so formula savvy

How do i edit this formula so I can pull data within a certain date range? for example, I want to pull data from July 1, 2025 through June 30, 2026

=IF(AND(OR(Status@row = "Validated", Status@row = "Completed", Status@row = "Hold", Status@row = "Active"), Type@row <> "Cost Avoidance", Type@row <> "Optimization", [Actual IMP Date]@row >= DATE(2024, 12, 1)), "YES")

@Paul Newcome

Find more posts tagged with

Accepted answers

Paul Newcome

@Not so formula savvy You would add another set to the AND function and update the date in that first DATE function like so:

All comments

Paul Newcome

@Not so formula savvy You would add another set to the AND function and update the date in that first DATE function like so:

Not so formula savvy

you're the best!!!😁

Paul Newcome

Happy to 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.