Hey There,
the texts are stored in a column. Whats the easiest function(s) to convert the following text format into date format. =date() requires year,month and date but i can't figure out how to extract them. (esp the month)
"30-SEP-07 12:00:00 AM"
"JUN 30 2010 12:00:00 AM"
reason is because i need to sort a column of dates but they are currently stored in text.
helpplease!
Bookmarks