Skip to content
+1-888-319-3663

COMMUNITY FORUM

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

Brenda asked 1 year 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
Ethan Sorenson Staff answered 1 year 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.