Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

I want find emp first in last out shift wise

Home
Forums

I want find emp first in last out shift wise

Vishnu Bhangale

8yAsked Sep 13, 2018, 11:50 PM740

hi,

I want to find emp first in last out in shift

when emp out next day swipe the out swipe consider in previous day

shift have multiple permissible time

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Vishnu Bhangale8y ago
Sep 14 2018 4:09 AM
i have shift table with starttime(14:30) and endtime(01:30) and night shift
each shift have four permissible time (in time, out time)
which is given in table
when user swipe on date 01/01/2018 14:00 in swipe
for out he swipe on 00:35 means 02/01/2018 00:35
but i want show result to consider swipe on day 01/01/2018 as out
like
EmpID UserName SwipeDate inTime OutTime
1 TEST 01/01/2018 14:00 00:35
Amit Gupta8y ago
Share some sample input with expected output