How to filter current month with year in filter data table

[sayed.tabrez]

Date
10/05/2021
11/05/2021
12/05/2021
13/05/2021
15/05/2021
17/05/2021
18/05/2021
19/05/2021
20/05/2021
21/05/2021
22/05/2021
24/05/2021
25/05/2021
26/05/2021
27/05/2021
28/05/2021
29/05/2021
31/05/2021
01/06/2021
02/06/2021
03/06/2021
04/06/2021
05/06/2021
07/06/2021
08/06/2021
09/06/2021
10/06/2021
11/06/2021
12/06/2021
14/06/2021
15/06/2021
16/06/2021
17/06/2021
18/06/2021
19/06/2021
21/06/2021
22/06/2021
23/06/2021
24/06/2021
25/06/2021
26/06/2021
28/06/2021
29/06/2021
30/06/2021
01/07/2021
02/07/2021
03/07/2021
05/07/2021
06/07/2021
07/07/2021
08/07/2021
09/07/2021
10/07/2021
12/07/2021
13/07/2021
14/07/2021
15/07/2021
16/07/2021
17/07/2021
19/07/2021
20/07/2021
22/07/2021
23/07/2021
24/07/2021
26/07/2021
27/07/2021
28/07/2021
29/07/2021
30/07/2021
31/07/2021
02/08/2021
03/08/2021
04/08/2021
05/08/2021
06/08/2021
07/08/2021
09/08/2021
10/08/2021
11/08/2021
12/08/2021
13/08/2021
14/08/2021
16/08/2021
17/08/2021
17/08/2021
18/08/2021
19/08/2021
21/08/2021
23/08/2021
24/08/2021
25/08/2021
26/08/2021
27/08/2021
28/08/2021
31/08/2021
01/09/2021
02/09/2021
03/09/2021
04/09/2021
06/09/2021
07/09/2021
08/09/2021
09/09/2021
11/09/2021
13/09/2021
14/09/2021
15/09/2021
16/09/2021
17/09/2021
18/09/2021
20/09/2021
21/09/2021
22/09/2021
23/09/2021
24/09/2021
25/09/2021
27/09/2021
28/09/2021
29/09/2021
30/09/2021
01/10/2021
04/10/2021
05/10/2021
06/10/2021
07/10/2021
08/10/2021
09/10/2021
11/10/2021
12/10/2021
13/10/2021
18/10/2021
19/10/2021
20/10/2021
21/10/2021
22/10/2021
23/10/2021
25/10/2021
26/10/2021
27/10/2021
28/10/2021
29/10/2021
30/10/2021
1/11/2021
2/11/2021
03/11/2021
08/11/2021
09/11/2021
10/11/2021
11/11/2021
12/11/2021
13/11/2021
15/11/2021
16/11/2021
17/11/2021
18/11/2021
19/11/2021
20/11/2021
22/11/2021
23/11/2021
24/11/2021
25/11/2021
26/11/2021
27/11/2021
29/11/2021
30/11/2021
01/12/2021
01/12/2021
02/12/2021
03/12/2021
04/12/2021
06/12/2021
07/12/2021
08/12/2021
09/12/2021
10/12/2021
11/12/2021
13/12/2021
14/12/2021
15/12/2021
16/12/2021
17/12/2021
18/12/2021
20/12/2021
21/12/2021
22/12/2021
23/12/2021
24/12/2021
27/12/2021
28/12/2021
29/12/2021
30/12/2021
31/12/2021
03/01/2022
04/01/2022
05/01/2022
06/01/2022
07/01/2022
08/01/2022
10/01/2022
11/01/2022
12/01/2022
13/01/2022
17/01/2022

how can filter current month and year
i tried “/”+now.month+“/”+now.year its not working

[Shikhar_Tandon]

Hi @sayed.tabrez ,

@sayed.tabrez

i tried “/”+now.month+“/”+now.year its not working

Try these
DateTime.Now.ToString(“MM”)
DateTime.Now.ToString(“yyyy”)

[Angel_Llull (Angel95)]

Hello @sayed.tabrez,

Try with: DateTime.Today.ToString(new system.Globalization.CultureInfo(“es-ES”)).Substring(2,10)

Doing this you will get CurrMonth/CurrYear