Does using JOIN with the End Date field that is part of a dependency not work properly?

I am trying to MATCH on two fields, so I am using JOIN to make one field.

The joined fields in my reference sheet are 1. a text field and 2. the END date field. When I MATCH to that JOINed field, I get #NO MATCH. But if I copy and paste that JOINed field into another field, I do get a match.

Is that END date causing this problem?

Find more posts tagged with

Accepted answers

All comments

James Keuning

Ugh. Nevermind. Turns out the 0 matters LOL.

Genevieve P.

Hi @James Keuning

Do you mean the 0 within the MATCH function? In any case, I'm glad you figured it out!

Cheers,

Genevieve

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.