Latest available data

[Anonymous]

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.

[jduarte12]

Hi,

Try creating a new field yearmonth (e.g., today, the year-month would be 201710) and the select max(yearmonth).

Regards,

João Duarte