Check if Column Values equal current date

Help
1

Hi All,

So I created a separate variable known as PublishedDateColumn assigned with

> ExtractDataTable.AsEnumerable.Select(Function(r) r(0).ToString.Trim).ToArray

ExtractDataTable being the Data Table, I then used a ForEach item in PublishedDateColumn

Using the if statement PublishedDateColumn.Equals(Now.ToString("dd MMM yyyy"))

It would filter the data table removing all values which are not the current date.

The problem is that PublishedDateColumn when using message box is being outputted as System.String() so it will always go to the else statement.

Any help would be appreciated. :slight_smile:

2

Fine
may i know the date format in that column use a writeline activity where mention as datatable.Rows(0)(“date-columnname”).ToString
so based on that we can come up with the expression
@Stabbathehut

3

it uses “dd MMM yyyy”

4

it is the one in excel
are we getting the same here in studio with the writeline activity

@Stabbathehut

5

Its just in a datatable and yes that is correct

6

great
so use this expression to get the rows with current date

datatable = datatable.AsEnumberable().Where(Function(a) CDate(a.Field(of string)(“yourcolumnnname”).ToString).Equals(Datetime.Now)).CopyToDatatable()

Cheers @Stabbathehut

7

Getting this error

image
image1289×414 14.1 KB

8

kindly add this assembly reference in main.xaml by opening that in notepad

Cheers @Stabbathehut

9

image
Added but no luck

10

Fine
close the studio and reopen the same xaml
you will be able to see the asenumberable function
and kindly type from your end so that you could see the functions and its arguments to be passed while typing

Cheeers @Stabbathehut

11

loop through your DataTable
and you use if condition like this
row(“yourcolumnname”).ToString = yourCurrentDateTime Variable

1 Like
12

Thanks for the easy solution :slight_smile:

1 Like
13

No Problem
@Stabbathehut cheers

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.