Advanced Search

Convert a String variable in the form ccyymmdd to a Date variable in the form dd.mm.ccyy

/ Published in: Other
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. COMPUTE tempdate=DATE.DMY(NUMBER(SUBSTR(linkdate,7,2),F2.0),NUMBER(SUBSTR(linkdate,5,2),F2.0),NUMBER(SUBSTR(linkdate,1,4),F4.0)).
  2. FORMATS tempdate (EDATE10).
  3. MATCH FILES FILE=*
  4.  /KEEP linkno TO linkscore tempdate dob TO scause10.
  5. RENAME VARIABLES (tempdate=linkdate).

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.