Filter Data Table for ends with Current DAte long form

I am trying to filter a datatable that has a column called Source.Name and that columns value ends with the current date written as November 10, 2022.xlsx. I don’t know the right code to make sure it filters properly. This is what I have so far.

use ToShortString instead of ToString

I still get an error. See below.

instead of Now(“MMMM-dd-yyyy”).ToString use:
Now.ToString(“MMMM-dd-yyyy”)

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