Simple Date Informat Question

[vinit_correia]

i have data in is8601 dt format.

eg:-'2016-09-15T12:40:23'.

i want to calculate number of days from 1960-01-01.

how do i get that

[Jagadishkatam · Accepted solution]

data have;
date1='2016-09-15T12:40:23';
date2='1960-01-01';
run;

data want;
set have;
days=intck('day',input(date2,yymmdd10.),datepart(input(date1,is8601dt.)));
run;

[vinit_correia]

thanks ...that was very helpful

[vinit_correia]

wouold it work if there wasnt a T in Date1?

[Jagadishkatam]

Since we used the informat is8601dt, we are expecting a T in the date1. Else it will not work.