I need query for the employees who joined a weak ago

[Satish Developer]

Hi, I have an employee table with employee data like empid, empname, empcreateddate. Every data new employees will join, so data is inserted in this table. I want to need reports weekly, to know, In this weak how many new employees are joined? How to do? can u give query for this? I am not getting the result, when i am using this below query Select * from Employees where EmpCreatedDate between convert(varchar,getdate(),101) and convert(varchar,getdate()-7,101)

G. Satish

[Syed Mehroz Alam]

See date functions from msdn here[^] DateAdd, DatePart and GetDate will be there to help you. Regards, Mehroz

[soni uma]

Try the following query Select * from Employees where EmpCreatedDate between select DATEADD(DAY, -(DATEPART(dw,GETDATE())-1),GETDATE()) and getdate() :cool:

[Khawar Abbas1]

Select * from YourTable where datediff( day, YourColumn, Getdate()) < 8

Do good and have good.