Subtracting Dates to determine what is less than 90 Days

Maybe I need to use a different formula, but this was successful in returning "Short" for everything, rather than anything under 90 days. We are trying to call out short start projects or those that require less than the average 90 days, so a difference of 90 or over should return nothing.

=IF([Anticipated Activation Date]@row - [Go Live/Close Date]@row < 90, "Short", "")

Find more posts tagged with

Formulas

Accepted answers

All comments

Tina Rustvold

I may have figured it out, but now need this information only for a particular service line. I tried below and recieve INVALID DATA TYPE error. Is this because I am mixing math and letters? I am unclear what data type is incorrect.

=IF([Go Live/Close Date]@row - [Anticipated Activation Date]@row < 60, AND([Service Line]@row = "Value-based Hospitalists", "VShort", ""))

Paul McGuinness

Hi @Tina Rustvold

Looks like the AND placement is wrong, try the below, AND needs to go in front of all the arguments.

=IF(AND([Go Live/Close Date]@row - [Anticipated Activation Date]@row < 60, [Service Line]@row = "Value-based Hospitalists"), "VShort", ""))

Hope that helps

Thanks

Paul

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.