Select last day with data

[#1]

I want to put a trigger to select last day with available data.

I have  DATE dimension with year-month-day

How I can do? Thank you.

Greetings .

[Anonymous]

Last day mean max available date in your data correct ?

[CELAMBARASAN · Accepted solution]

Use on open document trigger or button actions

Action --> Select in Field

     Field Name = DATE

     Value = Max({1}DATE)

Hope it helps

Celambarasan

[#4]

Thank you Celambarasan