Date column is not recognized as a Date in Reports

After adding two columns to a source sheet, my reports built over that file with filters on date columns stopped to recognize the date columns as date. The column in the original file still interprets the date column as date, but not on the reports built over it.

Log off / Log in
Remove / add the columns again.
Recreate the report.
Tried every step above after deleting the columns I've created.

Nothing seems to work.

Curiously, the calendar view works for my reports when filters are off. But they can not be filtered also.

Anyone can help me ? :*

Find more posts tagged with

Reports

Accepted answers

All comments

Debbie Sawyer

@Mike Khan

What other options do you have on your filter list? The "is not a date" is a filter condition that applies to Date Columns. Click the dropdown arrow to the right of "is not a date" and more filter conditions will show up...

The report looks fine to me. It might just be the filter condition showing is mis-leading you perhaps?

If this doesn't help, I am more than happy to connect via Zoom and see the issue in person?

Kind regards

Debbie

Mike Khan

Hey Debbie - Thanks for replying.

I've tested the error with other people as well to avoid being misled. But basically the report started to work again on the following day (nothing was changed). As we are facing some issues with performance , we considered this bug to also be associated with that .

Thanks again,

Mike

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.