Masking a Date

  • Thread starter Thread starter Josh
  • Start date Start 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
 
Add a calculated field in the query that returns Year([YourDateField]), or
set the field's Format to yyyy.
 
Back
Top