Return the Week Number and Month's name !

I have a date filed in an access report , i would like to find a function or something that will take the date value and return a string that tells the week number and the month's name ...

appreceate any help

You can use the DatePart function to return integers representing the components of your date..

eg

If your date is 12/16/2003

Code:

---

Dim weekday As Integer
Dim month As Integer
weekday = DatePart("w", date_value)
month = DatePart("m", date_value)

---

thanks for your reply ,, but can you tell me who can i put this in an expresion window in an access report please

Quote:

---

Originally posted by stono
I have a date filed in an access report , i would like to find a function or something that will take the date value and return a string that tells the week number and the month's name

---

To return the week number:

Code:

---

intWeekNumber = CInt(Format(Date(), "ww"))

---

To return the Month name:

Code:

---

strMonthName = Format(Date(), "mmmm")

---