hi

i would like to display the date and week number on one of my forms but have no idea about dates and how to code this.
can some one help? id appreciate it it beyond me :confused:

thanks :)

rob

the format function can actually determine a week no based on a date - loads of options - eg which is firstday of week, when does wekk 1 start etc. look at help

i still cant work this out. :confused:

i still cant work this out. :confused: If you post xactly what you want displayed, then we can post the parameters you need for the format command. Else search Access help for Format dates.

If you post xactly what you want displayed, then we can post the parameters you need for the format command. Else search Access help for Format dates.

sorted it now thanks for help