Format for Year

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen - 05 Jan 2006 17:33 GMT

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

Reply to this Message

Al Camp - 05 Jan 2006 17:43 GMT

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.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

> Hi,
>
[quoted text clipped - 5 lines]
>
> thx

Reply to this Message

Karen - 05 Jan 2006 18:02 GMT

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

> Karen
> Your field should be a Date field (ex. MyDate), not a Text field.
[quoted text clipped - 10 lines]
> >
> > thx

Reply to this Message