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: 73
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: 6,128
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
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th October 2018 - 04:53 PM