Date Related

[#1]

The attached is the application, in this I want to keep Min and max date only for particular employee on particular date.And if only in time or only out time is there then it should identify the missing entries.

Please Reply.

[sivarajs]

Not Clear what you want exactly

PFA

[#3]

Dear Sir,

Thanks for the reply.

In this, If There is IN time and No out time then It should give me that date entry as a missing entry like that person has forgotten to tap-out on that day, so it should find such kind of missing entries.

[sivarajs]

In the file which you have uploaded has all the in and out for employees

But you can add else condition to the expression to get null values

Timestamp(min(if([Time Event Type]='IN', SubField([Logical time],' ',1),'-')),'hh:mm:ss')