+1-888-319-3663

COMMUNITY FORUM

DATE FORMAT INCLUDES THE TIME AND I NEED THAT REMOVED ON THE FILE EXPORT

Brenda asked 3 years ago

My smartconnect is an export from SQL, the data in the preview shows the date as 4/30/2020, no time stamp. But when I export this data to a csv file the date is this: 4/30/2020 12:00:00 AM. How can I format this in the map destination export to file?

Answers

0 Vote Up Vote Down

Ethan Sorenson Staff answered 2 years ago

Brenda,
You can use a calculated column to format the date.
return Convert.ToDateTime(_SOURCEFIELD).ToString(“yyyy-MM-dd”)

If you would like to submit an answer or comment, please sign in to the eOne portal.