Offload Date Format

Dakota Haeffner

Hi,

I'm using Data Shuttle to Offload a title and some dates and it is coming through with a really wonky format.

Excel isn't able to auto convert this to a regular date and I tried using INT to try to make it into and integer but it returns a #VALUE! error because of the format.

Is there any solution to this? This seems like a issue that really impedes the usefulness of Data Shuttle.

Paul Newcome

Those strings are stored as text in Smartsheet. They are not stored as dates. You will need a helper column in Smartsheet (date type) with a formula to grab the date out.

=DATE(VALUE(LEFT([Column Name]@row, 4)), VALUE(MID([Column Name]@row, 6, 2)), VALUE(MID([Column Name]@row, 9, 2)))

Paul Newcome

Those strings are stored as text in Smartsheet. They are not stored as dates. You will need a helper column in Smartsheet (date type) with a formula to grab the date out.

=DATE(VALUE(LEFT([Column Name]@row, 4)), VALUE(MID([Column Name]@row, 6, 2)), VALUE(MID([Column Name]@row, 9, 2)))

Dakota Haeffner

Nice! Thanks @Paul Newcome !

Paul Newcome

Happy to help. 👍️