Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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())
Well my column name is Book_Date. so changed the formula to =Book_Date = =Month(Today()). but still no luck
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
Hello,
You can use the following statement:
= Book_Date >= monthstart(today()) and Book_Date<= monthend(today())
Hope it helps
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
Dine work in my case.
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
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!