Filtering data with date

Help Activities
, ,
1

Hello All,
I have an excel file, in that I need to filter with date for 40 days back. In column “PolicyToDate” if there is date of 06-09-2023 then I need 40 days back. so in filter data table I gave as column “PolicyToDate” contains Now.AddDays(-40).ToString(dd-MM-yyyy) but I’m unable to get the data.
Please help me in resolving an issue.

2

@ISBS_ROBOT
DateTime.ParseExact(str_Variable,“MM-dd-yyyy”,System.Globalization.CultureInfo.InvariantCulture).AddDays(-40)

4

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