Help required to modify my start date and to Date in Calender Object

[rajtechnocraft]

Hi Experts,

I have used the code to cretae my From Date and To Date Calender.

Attached is the code

It is working fine

I want little bit customisation to be done to it

My date data from the Date table is starting from 6th Jul 2009 where as in calender it will start from 1st

Can i default mu start date in my calender to 6th Jul 2009

And my to date should be greater than  my start date in my case it should be gretaer than 6th Jul 2009

How can i achieve this

Regards

arvind

[rajtechnocraft]

Sorry Kaushik,

Attached is the updated file

I can't send QVD  as it is client data.

Hence at UI also i just left few objects .

For testing the 2 calender objects

[kaushiknsolanki]

Hi,

     Can you tell me in this example of yours, your start date should start from what and end date should start from what?

Regards,

Kaushik Solanki

[rajtechnocraft]

start date should start from 6th July 2009

And end date start point should be grater than 6th July 2009

[kaushiknsolanki]

Try this for end date

Calendar2:

Load

*,

Day(End_Date) as EDay,

Month(End_Date) as [EMonth],

Year(End_Date) as [EYear]

;

Load

date(floor(recno()+$(vMinOrderDate)-1)+1) as End_Date

Autogenerate(vMaxOrderDate-vMinOrderDate+1);

Regards,

Kaushik Solanki

[rajtechnocraft]

Thanks Kaushik

But how do i make Calender 1 start from 6th July 2009 onwards as my data is there from 6th Ju.ly calender 2009

[kaushiknsolanki]

Hi,

     Currently your calander 1 is showing the data from 6th July 2009 onwards only.

     Correct me if I  am wrong.

Regards,

Kaushik Solanki

[rajtechnocraft]

Thanks Kaushik for the continous replies

Yes as i have written the default date macro selection On Opening the document

But can i write in the same macro where the user will not be able to clear this default date selection

Here is what i have written in macro page

sub selection

Active Document.clearall False

ActiveDocument.Fields("Start_Date").Select"06/07/2009"

end sub

and this macro is trggered on Document open.

Just want to add that users should not be able to clear this default Date selected.

Regards

Raj