by default current month & year should be in my calendar object

[Anonymous]

need help to get default  current month and year in my calendar object..

when i am opening calendar it is showing Jan 2012 but i need Feb 2015(current)

[mightyqlikers]

Hi,

go to sheet properties

triggers tab

action on activesheet

select in field

there in give the datefieldname and values as max ( datefield)

Regards

Samwise

[Anonymous]

[Anonymous]

If you make a selection, like Feb 2015, then close [save changes if requested] & reopen the qvw it should remember the selection.

Could you try & see if it does ?

[Anonymous]

default i want to show current month and year ..actually the data from 2012 so when i click on calendar object it is showing default Jan 2012..

is there any option to apply triggers??

[Anonymous]

Hi,

If you want to show only current months and year data in the calendar object

Create two variables

Let vMin = MonthStart(Today());

Let vMax = MonthEnd(Today());

Goto calendar object properties

Next select vMin variable

In the Min Value assign vMin and

Max Value assign vMax

Dynamically it will display current Month and Year dates.

OR

If you don't want to restrict  to only to current month and year.So user can select any date.

By default calendar object  should  show current month & Year

Create two fields based on the Datefield which is present in your model and on the basis of that create a table to find the Min and Max dates

LOAD Date(Min(Date)) as MinDate, date(Max(Date)) as MaxDate Resident Table;

Next create a variable Let vTodaysDate = Today();

And In the calendar object use this variable vTodaysDate.

In the min value  assign MinDate and in Max  assign MaxDate

Hope this helps

Regards

Neetha

[Anonymous]

You can use triggers, but do beware that some triggers do not work ion the Ajax client, especially Select triggers On Open which I why I avoid using them for things like this.

The annoying thing about this is that On Open triggers can all appear ok in the Desktop but then stop working in WebView / Ajax.

did have a look to see if you make a selection, like Feb 2015, then close [save changes if requested] & reopen the qvw it then remembers the selection

[Anonymous]

I tried but it's not working...

[Anonymous]

Could you share a sample qvw ?

[Anonymous]

it was a huge file i can't able to share you ...is there any other way to share??