Solved How to convert a month into a number in MS Access Query

[nector]

I want to a convert a month written like , 31/01/2025 into a number example = 1 etc , is there a function that I can use at MS Access Query level

I tried this below its not doing what I want:

Private Function GetMonthNumber(pstrMonthName As String) As Integer
Dim i As Long
For i = 1 To 12
  If pstrMonthName = MonthName(i) Then
     GetMonthNumber = i
     Exit Function
  End If
Next
End Function

 

[KitaYama]

In queries:

SELECT  ..... ,   Month(your_date_field) As YourFieldName From Your Table Where YourFilter

In vba :

yourVariable = Month(YourDate)

 

[bbfromgb]

you may try:

month(datevalue("31/01/2025"))

 

[Cotswold]

I'm a little surprised you need to ask this as it has been a standard Function in Access since day1.
Maybe get a copy of the Access Language Reference, which I'm sure will be helpful?

When someone starts a new computer language, I always suggest that they read the language reference if only to compare equivalent functions to improve understanding and familiarity. There are some Functions used more than others and the syntax is often different.

 

[Minty]

Day() , Month() and Year() are inbuilt functions that will extract the numeric values of those parts of a date field.
I too am amazed you couldn't find them via Google!

Functions (alphabetical list)

Office VBA reference topic

learn.microsoft.com

 

[Pat Hartman]

There are many useful VBA functions, Do a search for Access VBA functions and bookmark or print out the function list grouped by category. The alpha list is useless unless you know the name of the function you need. The category list shows ALL date related functions together where it is very easy to pick out the one you want. This is what I use when I can't remember the name of a function I don't use regularly.

 

[moke123]

Another quick and easy reference

MS Access: Functions - Listed by Category

For easy reference, we have provided a list of all Microsoft Access functions sorted into categories such as string, numeric/mathematical, date/time, advanced/logical, domain aggregate, data type conversion, group by, and file/directory functions.

www.techonthenet.com

 

[Pat Hartman]

The list on techonthenet.com is incomplete. Please bookmark the MS page

Functions (category list)

Office VBA reference topic

learn.microsoft.com