I had requirement like user want to fetch data using among dates like From Date and TO date among this dates i need to display number of employees leave details among employees based on Empid. I want Query regarding this requirement here in my database columns having From date only to date is n't available. Is there any hard code for to date.Help me regarding hw i need to approach i want query to genarate my crystal report .
select convert(char(8),fdate,112),convert(char(8),todate,112),count(empNo) from table
where datediff(d,fdate,@Fdate)>=0 and datediff(d,tdate,@Tdate)<=0
group by convert(char(8),fdate,112),convert(char(8),todate,112)
previous had somebody give query for this requirement but tdate is n't there in database how this tdate can do any query regarding this very urgent requirement.