Does anyone else have an issue with the date filter when using DataTable Connections?

I have an issue with DataTable and Sheet Connections where I will setup a connection and put in a date range filter between two dates 1st - 30th June, press save and the table will update with the data from 31st May and 29th June!

I go back in and the connections filter has changed to the 31st May and the 29th June!

In order to get the correct date, I have to set the filter for the 2nd June and 1st July. Press save and the table updates to the 1st - 30th June!

Does anyone else have this issue or is it just me?

Personal settings are to GMT and UK.

Find more posts tagged with

Sheets

DataTable

Accepted answers

All comments

Genevieve P.

Hi @Matthew LeMasonry

Is it possible this has to do with how your dates are being imported to DataTable? Here's another Community thread which discusses date format.

Otherwise, I would recommend following up with Smartsheet Support, including a screen recording of the behaviour you're describing and your personal settings, so you can troubleshoot this in a private channel.

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.