Date Format in tables

W

walter

I have a table with a field of type date.

What needs to be done to format this as mmm yy.

e.g. Sep-03

Regards,

Walter
 
D

Douglas J. Steele

A date field can only contain a complete date, so as long as you're storing
a complete date, you can display it as mmm yy by setting the field's Format
property to that format you've shown.
 

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

Date format. 2
Date Format - simple question 1
Why am I getting this error? 0
How to have two tables on same line? 1
Dealing with a Pivot Table (when I don't want to) 0
List all tables, including document structure 0
Macro to copy table of contents to a new doc 0
Dcount -Date Criteria - Won´t find it - 0

Top