Converting Character Set representing an interval to Date Variable
May 2, 2015 1:32 AM
| Last Modified: Oct 18, 2016 4:13 PM(6690 views)
Hi to everyone,
I have a set of data and the data variable is an interval in character where I would like to convert it to numeric date column with choosing either the first or the second character set as real date data. Tried text to columns but delimiter set apart each character by "-" and I couldn't "jump" further.