var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select Employees by start day for 8 month working
i have this column Sdate in my Employees table
this value represent the start date working
i need to get all of the employees that between 8 and 10 month of work from today
how can i do it ?
Use a date function like dateadd, datepart or datediff then write a SQL select statement with a where clause to filter the expected results.
Originally Posted by dotnet.il
hi thanks for your answer
maybe can u write me the query ?
This should get you started
Give it a try and if you get stuck post back your attempts and we'll give you pointers
, DateAdd(mm, -8, Current_Timestamp) As eight_months_ago