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

[sunilkumarqv]

Please find the attached file

Go to settings tab

sheet properties -Triggers -Onactivate Sheet-EditActions-Select in Field Search String as =Max(Date) then Save it

Hope you get desired results

[#3]

Hi Sunil

I don’t get.

Please see attachment

When I open document I can see the date lastly saved but not max.

Thanks

Raj

[MK_QSL]

Like This?

[#5]

Manish

I think you are referring Sample-1(3).qvw

If so than still does’t work. I tried the same but after saving doc and reopen again it pop up the date which you have saved last

Thanks for helping

Raj

[MK_QSL]

NOW?

[#7]

Manish

I saved with ‘03/01/2014’. When I reopen it was showing the same date but not ‘06/01/2014’

File attached here

Thanks lot

Raj

[ashwanin]

Hi

You have to do the below to set the maximum date.

Go to Setting -->Document Properties-->Triggers--> Select on open --> edit actions-->Choose Select in Field -->choose field Date and in search string put formula =max({1} Date) . Sample qv attached.

Use formula  =max({1} Date)

[#9]

Hi Ashwini

Now it’s woks perfectly fine.

I appreciate all of you for valuable efforts, Excellent job all of you did.

Thanks

Raj

[ashwanin]

If it works, then close the thread.

[sunilkumarqv]

So much of work contributed every one please make correct anwser