Format for Year

[Karen]

Hi,

I have a text field that has the form input format of 99/99/00;0;_ I would
like to format the field on the report to show only the year. Also can it be
formated with all 4 digits?

thx

 

[Al Camp]

Karen
Your field should be a Date field (ex. MyDate), not a Text field.
Then, on your report, a format of yyyy for MyDate would display only the
year.
Or, Year(MyDate) should work too.

 

[Karen]

Great thanks. I changed my table field from text to date/time. Then changed
the format to yyyy and it worked.