VBA : Date Format()

Hi Greg,

thanks a lot for the tips.

I've changed "filtrodata2" to string but now the result is the following:

Attachment 620259


Actually what i would as output in filtrodata2 is the date formatted from 03/06/2019 to 03.Jun.2019.

This is only a part of my code. The contents of filtrodata2 will be used to filter a file.

ActiveSheet.Range("A3:W3").AutoFilter Field:=18, Criteria1:=filtrodata2

Attachment 620266

where gg = dd
mmm = mmm
aaaa = yyyy

Thanks
Amedeo