You should first split the field into...
SPLIT([datetime], ' at ', 1)
SPLIT([datetime], ' at ', 2)
and then on the date part, just try the first part of your parsing string to obtain the date.
Thank you! The split worked great for time DATEPARSE("hh:mma" ,SPLIT([DateTime],' at ',2))
I am still struggling to get month day and year to parse. What would the format string look like for "December 21, 2014"?
1 of 1 people found this helpful
It should be this:
DATEPARSE("MMMM dd, yyyy", [Date field])