Convert char to date and subtract from today's date

Given the following table:
ID      PERIOD      DATA1
A      20070901      25
B      20060501      77
C      20071001      35
D      20070901      24
E      20071001      12
F      20070930      84
How can I convert PERIOD to its date format, and determine how many days it is from today's date?

Desired results would be similar to:
ID      DAYS      DATA1
A      43      25
B      531      77
C      13      35
D      43      24
E      13      12
F      14      84
TECHADVICEAsked:
Who is Participating?
 
dqmqConnect With a Mentor Commented:
Select ID, DateDiff(day,Convert(DateTime,Period,112), GetDate()) Days, Data1 from...
0
All Courses

From novice to tech pro — start learning today.