Calculation of Room Charges.

Hi Dipesh,

You can't Accept your own answer by functionality. Only you can do is to accept the answer provided by other user which is more helpful to you (if any). It'll motivate users providing answers and indirectly help users looking for answers, like you.

@Hemant Sir, Please see the picture.

I am unable to close this thread? Why I dont know? Please help me.

Yes that`s I am saying in my Answer @Hemant Sir and @Piyush Sir.

Can any one tick my answer as correct answer?

Thanks for valuable suggestions.

@Piyush Sir,

Your case is not fulfilling my query.

Case 1 : When StartDate is 7/1/2015 and EndDate is also 7/1/2015
In this case DATEDIFF = 0, means it is satisfying your case 1 to add 1.


Case 2 : When StartDate is 7/1/2015and EndDate is 8/1/2015
In case DATEDIFF = 1, where I want it should be 2.Not satisfying else case in your query.

So I should use only DATEDIFF(DAY, STARTDATE, ENDDATE)+1 in every situation.

Please give your valuable suggestion that am I right or wrong?

Hi Dipesh,


you can check this in if condition if startDate and endDate are equal then you can set totalDays as 1 other wise you can get totalDays from your DateDiff() function.


thanks

Hi Dipesh,

        in this situation use CASE in Sql Server
like :
 
SELECT CASE WHEN DATEDIFF(DAY,START_DATE,END_DATE) = 0 THEN 1 ELSE DATEDIFF(DAY,START_DATE,END_DATE) END

*Like And Accept this answer if helpfull.!!

@Piyush Sir, your answer is helpful to me, i.e.,
Sql Server : DATEDIFF(DAY, START_DATE, END_DATE)

But in this case I have to add +1 in equation(DATEDIFF(DAY, START_DATE, END_DATE))
because if startdate is 7/1/2015 and enddate also is 7/1/2015 than it will give us 0 that is wrong so I have to add 1.


Thanks for giving your precious time for my query.

Hi Dipesh,

        It means patient comes 11:00 PM and Out 12:01 AM than consider 2 days charges?


if I am not wrong than you can do by date only. 


 like,

Sql Server : DATEDIFF(DAY, START_DATE, END_DATE)

c# : (EndDate - StartDate).TotalDays

Put if condition as per days charges.

@Piyush Sir, yes that is 24 hr, but i want if a patient comes at 11 PM should be consider for charges applicable for that day.
Than After as passed 12 in Night he will be chargeable for next day charges(for 24 hr).

Thanks

Hi Dipesh,

        you are doing mistake in AM & PM. 12:01 AM to 11:59 PM means its a 24 Hours.
First you clear your and mine confusion, and you can do simply using if condition.