tell me about intnx, intcx functions?

Question Posted / guest

4 Answers
20880 Views
CitiGroup, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

tell me about intnx, intcx functions?..

Answer / natrajboga

the INTCK function counts the number of intervals between
the two dates

where as INTCX function advances the date or time values
by a given interval and returns a date or time values

for example:

data xxx;
count= intck('week','1aug1998'd,'31aug1998'd);
run;
proc print;run;
the result would be 5 (it represents the no of weeks)

data yyy;
count= intnx('month','1aug1998'd,1);
run;

proc print;run;
the result would be the 1sep1998. becaz it corresponds to
the beginning of the next interval.

Is This Answer Correct ?

15 Yes

1 No

tell me about intnx, intcx functions?..

Answer / vimal

INTNX not only adds the dates.. it also subtracts..

count= intnx('month','1aug1998'd,-1);

it will subtract one month from 1aug1988 and gives us the output.

Is This Answer Correct ?

8 Yes

3 No

tell me about intnx, intcx functions?..

Answer / ramesh varma

intck is tells you between dates.
intnx is tells you adding dates

Is This Answer Correct ?

4 Yes

1 No

tell me about intnx, intcx functions?..

Answer / swati

INTCK( interval, date1, date2 )
Gives the difference of dates between date1 and date2

INTNX( interval, date, n <, 'alignment' > )

It increments the date by the n value

I am beginer,I have answered this at my knowledge.

Is This Answer Correct ?

4 Yes

5 No

Post New Answer