Default week, month, year

[bartwelvaarts]

hello guys,

I want to create a default bookmark for my sheet based on the current week, month and year.

I tried this in my filter:

= [Mydate= today() --> Works

=month[MyDate]=month(today()) -->wont work

and the same for year and week, but this wont work either. Does someone have any tips or tricks?

[Anil_Babu_Samineni]

I could say that some format issue?

month(Date(Date#([MyDate], 'Your current format here')))=month(Date(today()) )