How to get the in between date from the months using c#.net

Posted by Kavi.Sirius under C# on 5/22/2012 | Points: 10 | Views : 952 | Status : [Member] | Replies : 4
hi,

i have problem to get the inbetween dates between the months,

for example,

table design:

employee fromdate Todate
kavi 05-1-2012 07-1-2012 (mm-dd-yyyy)

means

Actually the employee kavi apply the leave between those above days.that particular leaves are approved.

if employee kavi again apply the leave between these dates 05-1-2012 to 07-1-2012
they didt allow to apply the leave,because their is already the leave record for particular months



example
i kavi apply the leave between these dates 05-10-2012 to 06-06-2012 means
they didt allow,

i need to check the dates for particular employee is applied or not between before applied dates in database

some one help to get the dates between the months

Thanks in advance..

Regards
Kavi.n



Responses

Posted by: Fool2code on: 5/23/2012 [Member] Starter | Points: 25

Up
0
Down
So are you doing this on SQL side or c# side. Post some code where you want to do this.

By my view it can be done on both sides easily but since your business logic should be a part of C# . so it should be done at front end only.

Depends on your choice , post the code and will provide a solution.

Kavi.Sirius, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sekar.C on: 5/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Kavi,
send your coding lines first i see then give to idea.

Regards
Sekar.c

Kavi.Sirius, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kavi.Sirius on: 5/24/2012 [Member] Starter | Points: 25

Up
0
Down
hi sekar,

i got the solution for that query,
thank you for reply

Regards
Kavi.n

Kavi.Sirius, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sekar.C on: 5/24/2012 [Member] Starter | Points: 25

Up
0
Down
Congratulation .

Regards
Sekar.c

Kavi.Sirius, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response