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

Question on Date format

P: 7
I have a field month (datatype number) in my table and I want to display the month in words. I wrote:

select Format(Month,"mmmm") as month from mytable;

But it gives Dec for 1, Jan for 2 and so on.Please advice me on this. Thank you
Feb 8 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
This type of formatting has to be done against a Date, and you're trying to do it not by supplying a Date, but only a single Number!

So to format it you need to make it into a Date This will do it in VBA code and I suspect it'll serve your purpose:.

Format(Month & "/2/2010", "mmmm")

Note that the day and year really don't matter here and were chosen at random.

Welcome to Bytes!

Linq ;0)>.
Feb 9 '10 #2

P: 7
Thank you so much. This served my purpose.
Feb 9 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.