Filtering the data

sgaryali

Hi

I want to filter the data for those row which has punch-in and punch out for the same date.

For ex EMP ID 101 For date 09-03-2022 he has punch in and out for same in same day in first row.

I just want to take such type of rows where punch out is before 24:00:00.

How can we do this?

Thank you in advance.

Sample Punch File.xlsx

Ladarthure

Hi @sgaryali,

you can do this using a filter tool and using the custom filter. The main thing here is to transform both your texts to dates understood by alteryx. To do this you can use the formula DateTimeParse and then set the date format.

I did it with the formula below in the filter : DateTimeParse([Punch-In],'%d-%B-%y') = DateTimeParse([Punch-Out],'%d-%B-%y')

This formula transforms your text to a date and then compares both it does not take into account the hours/minutes

I hope it helps