Enter Date and it automatically put Year in Seperate Field 1

[useractive]

Is it possible to setup in a table that when the individual is going through and filling out the table and put in the date of the event, it puts the year automatically in the next field? Thanks, Swish

 

[THWatson]

If you are entering the data through a form, you could do it this way...

[EventDate] is the field in which the user enters the event date. (for example 10/12/03)
[YearDate] is a second field that derives its value from the [EventDate] field, using =Format([EventDate],"yyyy&quot

You would then have a field in the main table called YearDate

The fields I have used, of course, are examples. You would have to change them to suit your own field names.

Tom

 

[THWatson]

Sorry, I answered too quickly.

If you want to store the year back in the table...
1. Set up the table with an [EventDate] and set its format to mmm/dd/yyyy. Also a [YearDate] with a format as yyyy

2. In your input form, both the [EventDate] and [YearDate] fields will have their corresponding fields in the table as their source, and set their format to the same as it is in the table. The important one is the yyyy in the [YearDate]

3. In the AfterUpdate event of the [EventDate] put this code Me.YearDate = Me.EventDate

That should do it.

Tom

 

[dneufarth]

Not quite sure why a 'year' field is needed. The year can always be extracted from EventDate using the YEAR function in forms, reports, and queries -- YEAR([EventDate]).

Dave