How to get from date......?

[Vitaminas]

Hello,


I would like some help working with dates in Access.How i can take just the number of the month from a Date.
I hope that someone can help me, thank you.



Vitaminas

 

[longhair]

Vitaminas,
straight from help:
Month Function Example
This example uses the Month function to obtain the month from a specified date. In the development environment, the date literal is displayed in short date format using the locale settings of your code.

Dim MyDate, MyMonth
MyDate = #February 12, 1969# ' Assign a date.
MyMonth = Month(MyDate) ' MyMonth contains 2.

hth
regards,
longhair

 

[mkrausnick]

To assign it to a variable: month( <mydatevalue> )
To display it in a date field, format the date field as "n" or "mm".

Mike Krausnick
Dublin, California

 

[mkrausnick]

Oops:

To display it in a date field, format the date field as "n" or "mm".

should be

To display it in a date field, format the date field as "m" or "mm".

Mike Krausnick
Dublin, California