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.