Default Date in Form Field

[Helen]

Hi,

I have created a form that I use as criteria for a query. The user enters a
Start Date and an End Date by either typing it in or using a Calendar.

Is there a way I can set the default date in the Start Date field to be the
first of the previous year; 01/01/04 and the End Date to be the last date in
the previous month (also previous year) i.e. 10/31/04?

Thanks!

Helen

 

[Guest]

txtStartDate = DateSerial(Year(Date)-2, 12, 32)
txtEndDate = Dateserial(Year(Date)-1,Month(Date),0)

 

[Helen]

Brilliant I say.

Thanks!

Helen

txtStartDate = DateSerial(Year(Date)-2, 12, 32)
txtEndDate = Dateserial(Year(Date)-1,Month(Date),0)

 

[fredg]

Hi,

I have created a form that I use as criteria for a query. The user enters a
Start Date and an End Date by either typing it in or using a Calendar.

Is there a way I can set the default date in the Start Date field to be the
first of the previous year; 01/01/04 and the End Date to be the last date in
the previous month (also previous year) i.e. 10/31/04?

Thanks!

Helen

Set the Default Value property of the StartDate control to:
DateSerial(Year(Date())-1,1,1)

Set the Default Value property for the EndDate control to:
DateSerial(Year(Date())-1,Month(Date()),0)

 

[Douglas J Steele]

Any reason not to use txtStartDate = DateSerial(Year(Date)-1, 1, 1)?

 

[Marshall Barton]

I have created a form that I use as criteria for a query. The user enters a
Start Date and an End Date by either typing it in or using a Calendar.

Is there a way I can set the default date in the Start Date field to be the
first of the previous year; 01/01/04 and the End Date to be the last date in
the previous month (also previous year) i.e. 10/31/04?

Set the text box's DefaultValue property to:

DateSerial(Year(Date())-1,1,1)
and
DateSerial(Year(Date())-1,Month(Date())+1,0)