Deafault date while selection

[#1]

Hi All

I have one variable GDate which is max date of max Quarter.

I need this as default when I open a document, but the problem is it shows the date lastly selected and saved.

I tried to initialize by creating Trigger, but not working.

Any clue please?

Thanks in advance to all

Raj

[MK_QSL]

Before your trigger add one more trigger clear all..

i.e. Add >> Selection >> Clear All

[PrashantSangle]

Hi,

I think you are looking for clear all action.

You can find this in sheet properties

[aveeeeeee7en]

Hi Rajendra

Create on more Trigger "Clear All" before your Date Trigger.

Follow these Steps:

1) Right Click on Sheet

2) Select Properties

3) Go to Triggers Tab

4) Click Add Action(s)... under OnActivateSheet

5) Select Add

6) Click Action Type: Selection and Select "Clear All"

7) Set Ok

😎 Again Click on Add

9) Click Action Type: Selection and Select "Select in Field"

10) Set Ok  - Field - Date Search String - Max(Date)

Also See the Attachment.

Regards

Aviral Nag

[#5]

Hi Nag

I have performed all steps you mentioned here.

Still not working. Like if I have max date 12/31/2013.

Now I select 09/30/2013 and save. So when I open I should see 12/31/2013 but I am seeing the date lastly saved.

Thanks

Raj

[#6]

Even the attached QV file does the same, when open than pop up lastly saved date but not the max.

Thanks

Raj

[#7]

Hi Max

I have performed clear all and then max date.

Still not working. Like if I have max date 12/31/2013.

Now I select 09/30/2013 and save. So when I open I should see 12/31/2013 but I am seeing the date lastly saved.

Thanks

Raj

[#8]

Hi Manish

I have performed clear all and then max date

Still not working. Like if I have max date 12/31/2013.

Now I select 09/30/2013 and save. So when I open I should see 12/31/2013 but I am seeing the date lastly saved.

Thanks

Raj

[MK_QSL]

Can you upload your sample file please?

[#10]

Manish

In attached QV whenever I open it shows lastly selected date but not max date

Thanks

Raj