Return the week and month of year

[amal1973]

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

 

[DreamerZ]

You should be able to use the format function as in:

format(datefieldname, "ww/yyyy")

The ww is the code for the week number and the yyyy is for the 4 digit year. You can put any format in the "" like ww-yyyy or ww yyyy, etc.

Search for the Format function for more information.

Hope that helps.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[amal1973]

thanks for your soulotion , it got me closer to what i need .
thanks