Data shuttle date filter

David Friesen

Not able to filter dates, ie 1/1/1977 from source Excel sheet. The Excel sheet's date is a formula, would that be a reason it is not filtering dates in Data shuttle?

Paul Newcome

It is possible that the formula is outputting a string that Smartsheet does not recognize as a date.

Jennifer Langan

Related, I have had no luck at being able to filter out information coming from my Source Sheet by date. For example, I'd like the Data Shuttle instance to load the content of Column A (source) to Column A (target) if Column B (source) is greater than 12/25/19

Lisa Vercellone

I also have not been able to filter using dates in data shuttle.

Jake Gustafson

Curious about this topic as well. I ran into a data limitation for my Data Shuttle workflow to process (I do not have DataTable). So, I was hoping to filter my source file and only take the records from the last x days, but now I'm working towards editing/adjusting that input/source file to only have records from those last x days and letting the Data Shuttle workflow do its thing.

The other thing with my data is that the source doesn't have a date date field, it's got a date timestamp field, so not sure if that complicates matters even more, but what I'd love to have is an option to filter for records in the last 7-days or something like that.

kawind

Can anyone confirm (or deny) that date can be used as a filter in Data Shuttle?

David V12345

https://community.smartsheet.com/discussion/comment/429289#Comment_429289

Yes, I was able to get this to work. I needed to import a section of an externally generated report that has to many cells for Smartsheet, so I needed to filter the data table to only import partial data. I was able to use the greater than filter. The trick is to enter the search criteria as yyyy-mm-dd regardless of the input data format.