On Open trigger action

[Anonymous]

Hi

I want my report to open with defult week set as this week.

I have a load statement like:

Load

*,

Week(ActualStartTimeUTC) as AactualWeek

;

...

I then did:

document settings --> Triggers-->Document Event Triggers --> OnOpen action.

Please find below a screendump of my settings.

I assumed that when I now saved and then opened my document Week( the red circle) would be set.

But as you can imagine, I did not get the result needed.

Any advise?

BR

Dan

[MayilVahanan · Accepted solution]

Hi

Try like that

SearchString

=Week(Today())

[Anonymous]

Brilliant.

Thanks a lot.

BR

Dan