TECHADVICE
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.