Masking a Date

J

Josh

I have a date coming from a query in the format of
10/06/2003. In the report the only part I would like to
show is the year(2003). How can I set this up in my
report so that I can only see the year?

Thanks,

Josh
 
D

Douglas J. Steele

Add a calculated field in the query that returns Year([YourDateField]), or
set the field's Format to yyyy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top