Data Shuttle filter for dates after a certain date?

RAdamowicz

I'm trying to pull data from an Excel report into Smartsheet. I cannot change the parameters of the Excel report, but I only need rows that have been updated after a specific date to merge into Smartsheet. I tried adding a filter that is greater than the date, which works in reports, but Data Shuttle is still pulling in all of the rows. Any ideas why this might not be working? Here's a screenshot of the filter:

The "Last updated date" column is formatted in Excel as a date matching the format I input in the filter. Any ideas would be much appreciated - thanks!

Darren Mullen

@RAdamowicz This is a timely question for me to answer. I just make a Data Shuttle course for my Guru Elite members and this was a key point that I made, so it's fresh in my memory!

When filtering dates in Data Shuttle, you need to type the date into the Data Shuttle filter field in YYYY-MM-DD format. Here's a quick visual:

https://share.descript.com/view/7LaMQYImt37

Darren Mullen

@RAdamowicz This is a timely question for me to answer. I just make a Data Shuttle course for my Guru Elite members and this was a key point that I made, so it's fresh in my memory!

When filtering dates in Data Shuttle, you need to type the date into the Data Shuttle filter field in YYYY-MM-DD format. Here's a quick visual:

https://share.descript.com/view/7LaMQYImt37

RAdamowicz

Hi @Darren Mullen! Thanks so much for this! Do you know if the date columns in the Excel source file and Smartsheet target files also need to be formatted that way, or is it just in the Data Shuttle filter? Thanks!

Darren Mullen

@RAdamowicz No, they do not need to be formatted that way in the Excel or Smartsheet. It's purely how you format the filter in Data Shuttle.

Let me know if that works or if you ahve any issues!

RAdamowicz

It worked! Thank you so much!

Darren Mullen

@RAdamowicz great! Thanks for the follow up!!!