need suggestion

[#1]

In my application I want to show the current quarter data.It means if a  quarter starts from 21st march 2014 to 21st june 2014 than my application shows data only according to that current quarter and nd application will automatically update according to the current quarter.attached a sample excel which is showing how data is given in excel sheet.

need help to write script

[#2]

@pradeep taniparthy.i tried this,its dshowing the current year and current quarter dat but data is not freezes.we can change it.

i want that data to be frrezed when we open the document.

[PradeepReddy]

paridhi agrawal

Try the below settings along with the above options..

Add one more action on document opening.

Doc Properties--> Doc even Triggers--> On openingDoc--> Add--> Selection --> Lock Field --> Quarter (Field Name)

[#4]

@pradeep taniparthy if we do this than it locks that particular field.but if the data is again refresh than how it will change the data in application.

[PradeepReddy]

We are locking the field only not the value.  Whatever the current quarter, we are locking that only...

If you want to test the scenario,  take the data for next quarter... and change the expression in quarter selection to  ='Q'&Ceil((month(today())+2)/3).

After reloding the data... save the document, Close the document and open it again... it will work.