Date is present or not in datatable

Help Activities
, , , , , , ,
1

I need to check whether the end date in datatable is present or not without using for loop condition

3

Hi @sruthesanju ,

Can you pls provide us the sample or attach screenshot of Input Data and expected Output.

1 Like
4

Hi @sruthesanju

Can you provide us input and expected output. We can help you with condition.

Regards

1 Like
5

@sruthesanju

Please provide the input and output

1 Like
6

@sruthesanju ,

Probably you are looking for this.

image
image807×299 14.6 KB

Replace dt with your DataTable variable & StartDate with your end date's present in DataTable Column Name

Thanks,
Ashok :slight_smile:

1 Like
7

@sruthesanju

bascially we use this expression which gives output as boolean

dt.AsEnumerable.Any(Function(a) datetime.ParseExact(a("ColumnName").ToString,"dd/MM/yyyy",system.Globalization.CultureInfo.InvariantCulture).Equals(cdate(inputstr)))
1 Like
8

What is the dtmToCheck

1 Like
9

@sruthesanju

it is your input value to check