onOpen time select lastdate

[#1]

Hello,

I want to select last time on open time , How can i on  my qvd file?

Thanks.

[avinashelite]

Hi Murat,

You want to select the last time on which field ???? or your trying to get the user last login time

[#3]

Hi Avinash,

Thank you for your interest,

I want to see data on lastdate onOpen ,

If i select date field on last time ,Can ı see ?

[avinashelite]

see, if you are tracking and have date filed matching for it you can do.

NOTE: if your trying to see when the data when the user last login , this may not be possible

[#5]

Hi,

Can you please specify your query a bit more ?

But as far as I could understand, you need the data as it was 'selected' before last close.

There are quite a few possibilities to it. One of them could be;

You have a Year, Month selected which can be stored in a variable.

This variable can be passed to the trigger in document settings OnOpen Event Trigger, like in the image below;

Thus, when you open the  document next time, the last selected Month Year will be selected Default !

Hope it Helps!

Cheers !

[#6]

I try to select  date field (Start in my file) but ı cant,.  I have date field but ı cant select lastdate or today

[avinashelite · Accepted solution]

Hi

I check you file the reload date format and start column their is no match that's why its not selecting

try like this;

In the script

create one more column for start as below

load

start,

date(start,'DD-MM-YYYY') as match_date,

etc

then go to settings >trigger > on open> then select filed selection>select   match_date

and in the value : date(reloadtime(),'DD-MM-YYYY')

this will do

[#8]

Thank you so much Avinash.

[avinashelite]

No problem