Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a column with timestamp values as below format How can i get the date from this value
Jul 15 11:06:15 EDT 2015
Also is there any link or suggestion from where we can check or learn the various techniques or concept around reading and formatting the timestamp values
Try like this:
=DATE(Timestamp#(Replace('Jul 15 11:06:15 EDT 2015','EDT ',''),'MMM DD HH:MM:SS YYYY'),'YYYY-MM-DD')