Date

[border20]

If I have the following code

Dim date2 as date

date2 = date

how do i go about changing the month or the day to a numerical value of my choice like 1 ??

thx

 

[sambo]

Check out the WEEKDAY Function and the Month Function

Taken Directly From MSAccess Help..

Month(date):
Returns a Variant (Integer) specifying a whole number between 1 and 12, inclusive, representing the month of the year.

Weekday(date, [firstdayofweek]):
Returns a Variant (Integer) containing a whole number representing the day of the week.