Filters in sharepoint View

Hi All,

I am saving the Infopath form in the sharepoint Form Library. I would like
to provide filters to the All Items view which is the default view. I want to
display the forms saved in th current month in the Form library. All the
forms saved before that should not be displayed in the form libraray.

The column "EffectiveDate" is created by default in sharepoint. So I wanted
to provide the following filter to display the forms saved in the current
month.

if(Month(EffectiveDate) - Month(Today)) == 0)
then form is aved in the current month.

The problem is there is no way to get the Todays date in the calculated
fields in sharepoint.

I have tried different solutions but all of them failed.
I know that the query looks simple but when I tired to implement it none of
the solutions worked.

Can anyone help me please.

Thanks & Regards,
-Reetu


.