Check Date

Hello All,

I have some problem here, so i have datatable contains :
Employee Number | Date
aaaaaaaaaaaaaaa | 01/02/2020
aaaaaaaaaaaaaaa | 02/02/2020
x
x
x
aaaaaaaaaaaaaaa | 29/02/2020
bbbbbbbbbbbbbbb | 01/02/2020
bbbbbbbbbbbbbbb | 02/02/2020
and so on

Note :
the datatable are not contains with this row
Employee Number | Date
aaaaaaaaaaaaaaa | 03/02/2020
aaaaaaaaaaaaaaa | 04/02/2020

so my issue is, to find which date are missing from an Employee Number
please give me some solution.

Thankyou

you want which date as with employee number??

for example, no row
employee no | date
aaaaaaaaaa | 03/02/2020

i want to know that row doesnt exist

NB: you cant ask me if you still dont understand

Hi @aliaga

You mean to say that when the row comes currently you won’t process the particular row correct but process other rows

Thanks
Ashwin.S

i mean, i have to check the date one by one. and process the counter if any date missing (not weekend) on employee number aaaaaaa

Hi @aliaga

Check the condition as

string.IsNullorEmpty(row(“employee number”).ToString and based on condition you can process it accordingly

Thanks
Ashwin.S

Hi @AshwinS2,

my problem is ther are no row employee number on date 03/02/2020

hi @aliaga

Can you send the Excel file

Thanks
Ashwin.S

Hi @AshwinS2,

here the excel file,
for the example you can delete any row. and my issue is to find if any row(not weekend) by date asc are missing

test.xlsx (9.6 KB)

Hi @aliaga

Observed the Excel file there is no weekend added in Excel so you can do the sort and then try to process the Excel file

Thanks
Ashwin.S

Hi @AshwinS2,

yups, that true. cause it output after foreach and delete row date from weekend,
my issue is how to find the date are missing from that datatable, and that row are not weekend

Thanks

Hi @aliaga

Use Cdate(row(“Date”). ToString.adddays(-2). ToString and based on the condition you can iterate

Thanks
Ashwin S

Hi @AshwinS2,

sorry i still didnt understand

Do You mean whihc emloyeee has date empty ?
fro Eg. du u want to find the record where aaaaaaaaaaaaa has date empty

Hi @SyedShabaz03,

yup, but for note ther is no row aaaa for that date whis date or the row are doesnt exist on the datatable