Show a previous month in a calendar

[Carly]

I am using a calendar function which contains the same code as this thread in the dbx.zip download.

What I would like to do is automatically make the calendar open on the previous month (i.e so if it gets opened now, I want it to show July)

Is this possible?

Regards
Carly

 

[Mile-O]

First of month? End of month?

If you want you could even set both dates to the start and end of the month?

 

[Carly]

I would more often than not want to set the 1st Date & the 2nd Date to be the Start & the End of the previous month.

Is this possible?

 

[Mile-O]

Set the default values of your textbox:

StartDate textbox's default value:

=DateSerial(Year(DateAdd("m",-1, Date())), Month(DateAdd("m", -1, Date())), 1)


EndDate textbox's default value:

=DateAdd("d", -1, DateSerial(Year(Date()), Month(Date()), 1))

 

[Carly]

That is fab

Thanks