How to get Start and end date of month from Master Calender when opening sheet

[helen_pip]

Hello

I have a master calender set up which shows the Start Date and End Date for my dataset

However when the user enters the page I want the Master Calender to show the Start Date and End Date of the current month

My variables are as follows:

v_start_date (Min Start Date)

v_end_date (Max Start Date)

On Sheet Triggers I have tried to set a variable where the v_start_date = max(MonthStartDate) 

and another variable where the v_end_date = Min(MonthEndDate)

However my master caleder only brings back 01/04/2013

I am wondering whether I need to use a between statement on the triggers, but am unsure how

Can anyone assist?

Thanks

Helen

[swuehl]

Not sure what you want to achieve, would be easier if you could post a small sample.

In general, to calculate this month's start and end:

=monthstart(today(0))

=Date(floor(monthend(today() ))

[helen_pip]

Hello

Apologies for the delay, something came up

I have posted a QVW to my original post and the QVW has a master calender within it

What I want to achieve is that the default on the master calender shows the Start Date and End Date of the current month when the user enters the sheet

I.e. at the moment I would like the default setting on the master calender to show 01/04/2014 and 30/04/2014 as this is the last month loaded in

I am not sure how to achieve this with triggers

Kind Regards