0 Replies Latest reply on Sep 23, 2015 11:40 AM by MikeWile

    Timestamp to Date



      Timestamp to Date


      I am pulling a date from an external data source. The data is in timestamp format. I've created a field in my solution and using GetAsText and Left to strip off the time part, everything looks fine. When I export to Excel however, the "/" was being stripped out. I used Substitute to change the "/" to a hyphen thinking that would fix it. It's still stripping the hyphen out.

      Right now it's a calc field saving as text. I tried changing to date, but that didn't help.

      Any ideas on what is happening? I'm attaching a screenshot. The left side is what I see on screen; the one on the right is a screenshot from Excel. Thanks.