I am trying to change a field in the format ‘yyyy-mm-dd hh:mm:ss’ from a DateTime datatype to a Date datatype ‘yyy-mm-dd’. I am accomplishing this in the Formula tool with Left([DateTimeField], 10) but I am unable to change the data type in the formula tool and the output still has the full DateTime format in spite of the Left function.
Any idea how I can accomplish this?
Marked as spam
Please log in to participate..