How to get the Year Period as per the currentDate(GetDate())

Question

Hi How to get the Year Period as per the currentDate(GetDate()) depend upon Joining Date. For Example. Emp_No Joining Date As per todaycurrentDate(His One year period End) 1 14-Jul-2013 14-Jul-2017 2 14-Jul-2016 14-Jul-2017 3 01-Feb-2015 01-Feb-2017 How to do the query? I use the case but this one will not suite. CASE WHEN JoinDate Thanks Basit.

Rakesh · Answer

Hi Basit Khan Day count: select DATEDIFF(DDJoinDateGETDATE()) from Employee Month count: select DATEDIFF(monthJoinDateGETDATE()) from Employee Year count: select DATEDIFF(yearJoinDateGETDATE()) from Employee datepart format year yy yyyy quarter qq q month mm m dayofyear dy y day dd d week wk ww weekday dw w hour hh minute mi n second ss s millisecond ms microsecond mcs nanosecond ns if your problem solve accept ans.