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.
Answers
-
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
