Week Date

  • Thread starter Thread starter Paola
  • Start date Start date
P

Paola

I would like to populate a column to display the week
value and not the exact date. Any suggestions?

Paola
 
Weekno: Format([MyDate], "ww")

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
I would like to populate a column to display the week
value and not the exact date. Any suggestions?

Paola
Click to expand...

Do you mean the week of the year (1 - 52/53)?
=DatePart("ww",[DateField])
 
Thanks for your help with the weekday solution. I would
like to group by week but display the week with mm/dd/yyyy
versus ww.

Paola
-----Original Message-----
I would like to populate a column to display the week
value and not the exact date. Any suggestions?

Paola
Click to expand...

Do you mean the week of the year (1 - 52/53)?
=DatePart("ww",[DateField])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top