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

Matthew LeMasonry

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.

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