How to compare dates

hi how can i compare date i.e 05/29/2019 to todays dates

i am getting the date from dt as string value

@manojv02500
have a look here on the different statement for parsing and compare

with importing of the namespace below the statement can be shortened:
grafik

@ppr hi i need to compare whether the date from datatable matches todays date or not

i am getting the date from dt as string value

in general it should be the same. eg. iterating with for each and date retrieval with row(ColumnNameOrIndex)… Myber the format pattern hast to be changed (Inspect the datatable content for this)

find some starter help here:
DT_FilterDates_byToday.xaml (8.5 KB)

New Microsoft Excel Worksheet (2).xlsx (8.6 KB)

can you help with this sample data

which column is to filter?

header with maker

row(1) date to compare with current system date if same or not

Sequence1.xaml (10.3 KB)

please check this

@manojv02500
manojv02500_TodaysDateFilter.xaml (7.5 KB)

  • used columnindex due the coumn had spaces on end of name
  • checked if date = today
  • currently only older dates are present, just change 1 date to todays date for testing purpose