Convert Tex to date with Data uploader

Matt@spec

Good Afternoon,

We are currently using Data Uploader to automatically move date into Smartsheet. In a few of our sheets the Date is the only unique identifier. However, I have found that using a date column to import does not work as it doubles the entries. If I upload the dates as plain text I have no issues. I have converted a many texts into dates in my time but this one seems to be alluding me. The current date comes into smart sheet as follows: 02/01/19. I am able to get it to read as a date but it will not filter nor report properly as a date. Does someone have a formula that may work to convert this to an actual date?

 

Thanks in Advance!!

Anthony M.

Hi Matt,

Thank you for reaching out! We would love to look into this deeper with you. Would you be able to submit a ticket with our Support team for continued troubleshooting on this?

Please use the following form to submit a ticket.

https://help.smartsheet.com/contact

Thank you for your time, Matt. We look forward to working with you!

Kind Regards,

Anthony

Smartsheet Support