Hi guys,
I need to select the last year and the last month avaibles when I reset the filters.
The system data is updated automatically, so when I open the file, or when I reset the filters, I would see the latest data.
I can't use:
- year(today())
- month(today())
because I couldn't have this month's data, but maybe I have the data of the previous month.
How can I do this?
Last thing, years are numeric value, but months are a string value.
Thanks.
