auto display before 24 hours and after 24 hours

Ravi Kiran Chanduri,

No. it's based only leave from .

mean. select Leave from , to check current date to leave from >24 or <24.

and. how to change timezone in hosting details .

hosting time is less than 5.5 hours to india time.

its display universal time 3:03am to indian time 8:34 am .

how to change indian time in hosting?

Hello Rupesh,

Are you asking like below?

If ( selected leave period is less than a day ) then Select one kind of leave

else Select another kind of leave.

If Yes,

get the hours from the Leave to - Leave from,

If the result is > 24 then return suitable Leave type else returns another Leave type.

Let me know your question little more clear to give our best .

Thanks

Hello,

Your question is not fully understandable.

You can use case statement in sql server.

Thanks

Suraj