adding current date as filter to bookmark

[fernfrancis]

Hi Team,

I am trying to make a dynamic filter so that when the page loads it give the data for the current month. When i try this it gives me the correct data *-05-2022  but when i try to make it dynamic by using the expression =Month(Today()) it does not fetch any data. 

If someone can help me with this to so that i can save it as a bookmark. 

[salonicdk28]

Try this in your month filter and then on entering save it as default bookmark, it will fetch the data only for the current month whenever you open the application

=Month=Month(Today())

[fernfrancis]

Well my column name is Book_Date. so changed the formula to =Book_Date = =Month(Today()). but still no luck

[salonicdk28]

You need to calculate month field first  from Book_Date like Month(Book_Date) in the script and then in the month filter, write the expression as mentioned above, hopefully it will work 

[HugoRomeira_PT]

Hello,

You can use the following statement:

= Book_Date >= monthstart(today()) and Book_Date<= monthend(today())

Hope it helps

[fernfrancis]

I Tried what you mentioned, but when i try to use the filter =Month(Today()) it fetches all the months does not select the current month

[fernfrancis]

Dine work in my case. 

[salonicdk28]

You need to write like below expression in the filter-

=Month=Month(Today())

and if your  issue is solved please mark the answer with Accept as Solution.

Thanks,

Saloni

[HugoRomeira_PT]

Hi

1. You must select the field that you wish to filter and apply the expression = Book_Date >= monthstart(today()) and Book_Date<= monthend(today()), then press enter, and click on confirm selection button (green check)

2. Then create the bookmark, give it a name and confirm

3. After it's create you will see that the bookmark has the following definition

note: in my case I've applied as well another filter to the bookmark: vendor type={'External'}, you should ignore this part

4. Test it, it should work

Hope it helps!