display date and week number??

[rob.low]

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

thanks

rob

 

[gemma-the-husky]

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

 

[rob.low]

i still cant work this out.

 

[Rabbie]

i still cant work this out.

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.

 

[rob.low]

sorted now thanks

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