Using Boolean Operators in Countif with Dates

Hello. I'm not sure why my formula isn't working. I'm guessing the issue is my syntax but I don't see where it is wrong, if that is the issue.

I'm trying to get countif to count the number of rows with a date greater than 1/1/20. The formula does return a value but that value is 0. Here is the formula in case it's hard to see in the screenshot

=COUNTIF({Sofie's Org[TD Trans Date]}, ">" + DATE(2020, 1, 1))

I included a screenshot of the reference column. Clearly there are some dates that are greater than 1/1/20. The reference column is set to date column type.

When I try this in Excel I get a value of 3394 with the analogous formula =COUNTIF(Table1[TD Trans Date],">"&DATE(2020,1,1)).

Any help would be appreciated

Find more posts tagged with

Accepted answers

Edgar Meza Cabrera

Hello. After a bit more research I found the solution.

It seems using @cell in formula instead of concatenating the ">" to the output of the date function is the way to go (btw what do we call @cell like elements? It wouldn't be formula. Maybe it's calling a function?)

Anyway, here is the syntax to use based on my initial question.

=COUNTIF({Sofie's Org[TD Trans Date]}, @cell > DATE(2020, 1, 1))

All comments

Edgar Meza Cabrera

Hello. After a bit more research I found the solution.

Anyway, here is the syntax to use based on my initial question.

=COUNTIF({Sofie's Org[TD Trans Date]}, @cell > DATE(2020, 1, 1))

Genevieve P.

Hi @Edgar Meza Cabrera

I'm glad you found a solution! Thanks for posting it to help other members.

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.