By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,290 Members | 1,739 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,290 IT Pros & Developers. It's quick & easy.

Date formatting so "01/22/2005" becomes "January, 2005"

P: n/a
Any suggestions for a formula that will format a date this way? TIA!

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
See the Format() function in help. You'll be looking for:

Format([YourDate], "mmmm, yyyy")

Note that you'll want to store the date physically as the regular date
value and NOT as the formatted value as it will convert to being a text
string. Also, that will disable you from being able to sort properly
on the field (in reports/queries).

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.