Data Row filter with date greater than Partcular date

Hi,
Anyone can help me by using which query to filter the Datatable?
Best Regards,
Likith Rajesh

Hi @likith_rajesh

Check this

Dt = dt.Select("[Date]>= Now.ToString").CopyToDataTable()

Thanks
Ashwin S

3 Likes

@AshwinS2
What is the date format we have to use ?
Best Regards,
Likith Rajesh

Hi there!

now.tostring can be tweaked to whatever works best for your workflow. If you needed, say 08-2019, you can do now.tostring(“MM-yyyy”). Some more info on how you can format this below, but I recommend playing around with log messages to make sure you get the desired output.

Hope this helps!

https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

3 Likes

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