Default Bookmark question

[Aag]

Hello all,

I have a Date picker which has Fromdate and Todate. I need to create a default bookmark which always opens the latest month until the maxdate it is refreshed.  

I have it 

date(min(Orderdate),'MM/DD/YYYY')

date(max(Orderdate),'MM/DD/YYYY')

Can someone help how to create bookmark with always latest month? When i create this, it does not show the latest date updated when the dashboard is refreshed. Not sure what is wrong. 

[agigliotti]

Hi @Aag ,

to create a dynamic bookmark for the last month:

=Orderdate>=MonthStart( max(Orderdate) ) and Orderdate<= MonthEnd( max(Orderdate) ) 

I hope it helps.
Andrea

[Aag]

@agigliotti  Thanks for your response. So where do I give this condition? I have a date calendar as a range from date and Todate. I need to create default bookmark with this condition. Can you please let me know? 

[agigliotti · Accepted solution]

just type that expression in a listbox searching for Orderdate field , then you'll be able to create the bookmark.