Get Month from Date [Archive]

Click to See Complete Forum and Search --> : Get Month from Date

April 9th, 2001, 02:49 AM

Hi, Nice day.
I have a question about the Date.
how can i display the month and year only from the date saved in the access database?

TH1

April 9th, 2001, 03:22 AM

use the format$ function

Mydate=format$(Mydate,"mm/yyyy")

There are plenty of different formats you can use have a look in the help files