Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a dashboard and Detail. When I open them I want them to default to current month.
Hi Ed,
Try this:
load a new field with the value 'current month'
Dates:
Load
Date
from <>
change to:
CurMonth:
Load
Date,
'Current Month' as CurrentMonth
resident Dates
where monthname(Date)=monthname(Today());
After refreshing apply a selection on CurrentMonth='Current Month'
Save/Publish the app.
Every time you refresh, 'Current MOnth' will only be associated with the dates from today's month.