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
Printable View
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
To return the week number: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 Month name:Code:intWeekNumber = CInt(Format(Date(), "ww"))
Code:strMonthName = Format(Date(), "mmmm")