Week of Year

  • Thread starter Thread starter rena
  • Start date Start date
R

rena

Hi All,
I would like to know if there are ways / function to display the week of
year within the query using a field named "Inputdate".

Thanks a lot
Rena
 
DatePart("ww", [InputDate])

Take a look at the Help file entry for DatePart, though. There are a couple
of optional parameters you can play with to control how Access determines
the week number.
 
Hi Douglas,
Thanks for helping,
Also Is there ways to make also the
Month([Inputdate]) to a string like "January", "March",
"Decemeber"......etc.??


Douglas J. Steele said:
DatePart("ww", [InputDate])

Take a look at the Help file entry for DatePart, though. There are a couple
of optional parameters you can play with to control how Access determines
the week number.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



rena said:
Hi All,
I would like to know if there are ways / function to display the
Click to expand...
week
of
year within the query using a field named "Inputdate".

Thanks a lot
Rena
Click to expand...
Click to expand...
 
Format([InputDate], "mmm") will return Jan, Feb, Mar, ...

Format([InputDate], "mmmm") will return January, February, March, ...

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



rena said:
Hi Douglas,
Thanks for helping,
Also Is there ways to make also the
Month([Inputdate]) to a string like "January", "March",
"Decemeber"......etc.??


Douglas J. Steele said:
DatePart("ww", [InputDate])

Take a look at the Help file entry for DatePart, though. There are a couple
of optional parameters you can play with to control how Access determines
the week number.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



rena said:
Hi All,
I would like to know if there are ways / function to display the
Click to expand...
week
of
year within the query using a field named "Inputdate".

Thanks a lot
Rena
Click to expand...
Click to expand...
Click to expand...
 
Back
Top