Trade Knowledge Home -> Trade Question-> Industry >> Access database, how to get the date of the month

Access database, how to get the date of the month

Users questions:Now an ACCESS database, which has a date field, and now want the date of the month, how to get it? Have that a function to do this? For example, May is the month to find out all the records. Thank you
Experts answer:select * from table where Month (field name) = 5
  • This information provided by the users.Thanks!