Date with Time uploading in Data Shuttle comes only with Date

MikeS

This is a peel off of this older thread on the topic: https://community.smartsheet.com/discussion/95065/date-with-time-uploading-in-data-shuttle-comes-only-with-date

I have a source xlsx file that is auto-generated and sent to me each morning. It comes with a date and time on the same line, but only the date portion comes over when data shuttle does it's morning update.

The cell in my source looks like this:

The "function line" in my source is this:

Is the only option still to open the xlsx sheet and create the new column with this function [ =TEXT(A1, "DD/MM/YYY HH:MM") ] so the time can be imported into DS correctly? To me, that defeats the purpose of DS automating this for me each morning.

Interestingly enough, if I import the xlsx as a new sheet not using DS, it lists the times only.

However, when I use DS to import it, it lists the date only.

In my situation, all I really need is the time. There is another column with date on my sheet.

Thank you for any help you can provide!

Ash A.

Hey Mike, you can use 'Expressions' within your Data Shuttle workflow so that you don't have the separate that data out in the source sheet. By doing so, any new .xlsx file will parse through, looking at the Expressions you've set.

Think of Expressions as a place to use a formula to transform you data before it's outputted into a Smartsheet sheet. Here's a Community Post with an example on how to set this up (scroll all the way down): https://community.smartsheet.com/discussion/94939/how-to-use-data-shuttle-expressions

MikeS

Hmmm, interesting. Thanks. I've got some playing to do. I haven't ever looked into expressions before. I'll report back with questions or (hopefully!) my solution.

MikeS

Unfortunately I can't get this to work....

I did a simple =RIGHT([ENR Time]@row, 8) for my expression to try and capture the right 8 characters (time) that's in my source:

The result I got was the 8 characters from the date: