Query Part of Field

[Scott]

I have a database with a date field. The field is formatted as 2 digit month,
2 digit day and 4 digit year (example: 05/10/2006)

Is there any way to query just the year part of the field?

Thank you!

 

[Rick B]

If it is actually a date field, then the format is not relevant. You can
display a date field in any format you like.

To pull out the year, use the following:

=Year([YourField])


If the field is NOT a date field. If it is a text field, then try this...
=Right([YourField],4)

or

=Right([YourField],2)

 

[Scott Nash]

Thanks..

I tried =Year([myfield]) and it returns no results.

The other suggestions you gave me returned an error regarding diff data
types.

Thanks for your help!

If it is actually a date field, then the format is not relevant. You can
display a date field in any format you like.

To pull out the year, use the following:

=Year([YourField])


If the field is NOT a date field. If it is a text field, then try this...
=Right([YourField],4)

or

=Right([YourField],2)




--
Rick B

I have a database with a date field. The field is formatted as 2 digit
month,
2 digit day and 4 digit year (example: 05/10/2006)

Is there any way to query just the year part of the field?

Thank you!