UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Getting Name Of Month, Access 2000    
 
   
bshfdan
post Nov 29 2017, 07:52 AM
Post#1



Posts: 64
Joined: 17-March 04



Is there a way to get the name of the month in Access 2000? Thanks
Go to the top of the page
 
DanielPineault
post Nov 29 2017, 08:29 AM
Post#2


UtterAccess VIP
Posts: 5,454
Joined: 30-June 11



It depends in which context you are talking. Are you dealing with a month no. or a full date? See below for a few options.

CODE
Monthname("11")

or
CODE
Monthname(11)

Retuns November


CODE
Format(Date(),"mmm")

Returns Nov


CODE
Format(Date(),"mmmm")

Retuns November

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 02:42 PM