AnsweredAssumed Answered

Timestamp to Date

Question asked by MikeWile on Jun 6, 2015


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.