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?
Answers
-
It is possible that the formula is outputting a string that Smartsheet does not recognize as a date.
-
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