Drop down box default to this month

I log energy demand data to a SQL table. I have a dataset which holds my monthly power bill start and stop dates. I use these dates to query for max energy draw during the selected billing cycle. The question is how do I make the drop down box default this month’s billing cycle when the screen is opened , but also allow user to select a different date?

Thanks

Add the code to the Date binding:

dateArithmetic(now(0),-1, "month")

If you just use now(), it will keep updating.

Cheers,
Chris

1 Like