How to get the "Year" our of a "date"

Access 2003

Unbound box with this control Source:

=Forms![Dashboard-SafetyManagement]!txtEndDate

I want to show just the year

Tried several variations of this:
=Forms![Dashboard-SafetyManagement]!Year([txtEndDate])

Any help here will be appreciated.

Thanks in advance
dave

Use the Year function with the entire expression:
=Year(Forms![Dashboard-SafetyManagement]![txtEndDate])

"Dave" dave@accessdatapros wrote in message
...
Access 2003

Unbound box with this control Source:

=Forms![Dashboard-SafetyManagement]!txtEndDate

I want to show just the year

Tried several variations of this:
=Forms![Dashboard-SafetyManagement]!Year([txtEndDate])

Any help here will be appreciated.

Thanks in advance dave

Tried that before I posted also and it did not work.

However
formatting the field to: YYYY did work

Thanks much

dave

"BruceM" wrote in message
...
Use the Year function with the entire expression:
=Year(Forms![Dashboard-SafetyManagement]![txtEndDate])

"Dave" dave@accessdatapros wrote in message
...
Access 2003

Unbound box with this control Source:

=Forms![Dashboard-SafetyManagement]!txtEndDate

I want to show just the year

Tried several variations of this:
=Forms![Dashboard-SafetyManagement]!Year([txtEndDate])

Any help here will be appreciated.

Thanks in advance dave

It worked in my test, but perhaps in your project there was already a fomat
in the text box or something like that. Formatting is a perfectly valid
approach, too. Probably better, in fact.

"Dave" dave@accessdatapros wrote in message
...
Tried that before I posted also and it did not work.

However
formatting the field to: YYYY did work

Thanks much

dave

"BruceM" wrote in message
...
Use the Year function with the entire expression:
=Year(Forms![Dashboard-SafetyManagement]![txtEndDate])

"Dave" dave@accessdatapros wrote in message
...
Access 2003

Unbound box with this control Source:

=Forms![Dashboard-SafetyManagement]!txtEndDate

I want to show just the year

Tried several variations of this:
=Forms![Dashboard-SafetyManagement]!Year([txtEndDate])

Any help here will be appreciated.

Thanks in advance dave

I very likely could have tried the first example BEFORE I set the formatting
(originally it was mm/dd/yy), which I assume would keep it from working the
way I wanted.

Thanks

dave



"BruceM" wrote in message
...
It worked in my test, but perhaps in your project there was already a
fomat in the text box or something like that. Formatting is a perfectly
valid approach, too. Probably better, in fact.

"Dave" dave@accessdatapros wrote in message
...
Tried that before I posted also and it did not work.

However
formatting the field to: YYYY did work

Thanks much

dave

"BruceM" wrote in message
...
Use the Year function with the entire expression:
=Year(Forms![Dashboard-SafetyManagement]![txtEndDate])

"Dave" dave@accessdatapros wrote in message
...
Access 2003

Unbound box with this control Source:

=Forms![Dashboard-SafetyManagement]!txtEndDate

I want to show just the year

Tried several variations of this:
=Forms![Dashboard-SafetyManagement]!Year([txtEndDate])

Any help here will be appreciated.

Thanks in advance dave