ge all date record between two date even Date specific date record is not present

Question

0.00/5 (No votes)

See more:

Hello Friends
I have a problem that i want to data between Two date .on sunday holiday.even though i get sunday Date in my Records..

Ex
IF i entered 1-1-2013 and 31-1-2013
it shows Record as

1-1-2013
2-1-2013
3-1-2013
...
...
...
...
...
...
...
...
31-1-2013

Posted 29-Jan-13 23:51pm

hardy panchal

Add a Solution

Comments

Ankur^\m/ 30-Jan-13 6:39am

So do you not need weekends (or specific day in your result)? how would Sql know that. You must write the condition in your query. Show us your query and we might be able to help with your issue.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MT_ · Answer 1 · 2013-01-30T00:21:00

Solution 1

So what exactly the issue? you given 1-1-2013 and 31-1-2013 and its giving the data.

Also spcify where you are fetching data ? SQL? If yes, you may have to use correct operator. For example

SQL

select * from table1
where 
date < endDate and
date > startDate

Hope that helps
Milind

Posted 30-Jan-13 0:21am

MT_

Comments

Ankur^\m/ 30-Jan-13 6:40am

Your answer seems more like a comment to me.

hardy panchal 31-Jan-13 1:09am

actually sir i Did the same thing bust still it get record that it inserted on that dat not all date

MT_ 31-Jan-13 1:10am

as everyone said, show your code i.e. SP , you may remove/modify if there is any sensitive information.

hardy panchal 31-Jan-13 1:34am

ALTER PROCEDURE [dbo].[GetDaillyAttendanceReport]

@FDate DateTime =null,
@TDate DateTime =null
AS
BEGIN
select
D.*
(case when (Presence='P') then 'P' when (Presence='A') then 'A' else '' end)as Att
from Usp_Getdate('01-01-2013','01-31-2013') a
left Join DailyAttandanceEntryMaster as D on a.date=D.date

where (@EmpID is null Or @EmpID=0 or D.EmpID=@EmpID)

And (D.Date Between @FDate and @TDate) Order by D.Date

Usp_GetDate is Function For get All Date and compare it with DailyAttendanceMaster...bt it get only match date data not all Date

MT_ 31-Jan-13 1:44am

so it is getting data of 01-Jan-2013 and 31-Jan-2013 only? And you want all 31 days data. Is that right understanding? If yes, need to see USP_GetDate function.

hardy panchal 31-Jan-13 3:15am

ALTER FUNCTION [dbo].[Usp_Getdate]
(
@startDate DATETIME,
@endDate DATETIME
)
RETURNS @date TABLE
(
date datetime NOT NULL
)
AS

begin
WITH dates(Date) AS
(
SELECT @startdate as Date
UNION ALL
SELECT DATEADD(d,1,[Date])
FROM dates
WHERE DATE < @enddate
)
insert into @date
SELECT Date
FROM dates
OPTION (MAXRECURSION 0)
return
end