Format for Year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Great thanks. I changed my table field from text to date/time. Then changed
the format to yyyy and it worked.
 

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

Similar Threads

Conflict with short date and default input mask 1
Access Report Dates 1
How to check if date is > year 2000 3
Form with filter 4
Data entry form 1
Mask requirements 1
Windows 10 New Win 10 File Explorer 2
Run-Time Error '2107' 10

Back
Top