Converting Character Set representing an interval to Date Variable

saitcopuroglu

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.

Many thanks for your help!

pmroz

Create two new columns, Date1 and Date2.  Set the format of each to be "yyyy-mm-dd".  Add the following formulas:

Date1

Informat( Substr( :Date, 1, 10 ), "yyyy-mm-dd" )

Date2

Informat( Substr( :Date, 14, 10 ), "yyyy-mm-dd" )