Return the Week Number and Month's name !

[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 ...

appreceate any help

[federal102]

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

eg

If your date is 12/16/2003

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

[stono]

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

[MileOut]

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:

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

To return the Month name:

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