Sunday (First Day of Week)

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I'd like to pull the Sunday date for my
[PLANNED_START_DATE] field. Can you help with the format
statement - I can't get it to work.

Thanks!
Mary
 
? Pull the Sunday date? Can you give us more info? Example data in the table
and example data that should display?
 
I'm running a query on all activities for July by week. We
want to have a field that shows the date for the Sunday of
that week. The field it's pulling from is
[PLANNED_START_DATE]. Each activity has a planned start
date. The query should have a field that populates with
the Sunday date associated with the planned start date so
I can sort on that field. We'll always want the Sunday of
the week the planned start date falls in. Does that help?
-----Original Message-----
? Pull the Sunday date? Can you give us more info? Example data in the table
and example data that should display?

--

Ken Snell
<MS ACCESS MVP>

I'd like to pull the Sunday date for my
[PLANNED_START_DATE] field. Can you help with the format
statement - I can't get it to work.

Thanks!
Mary
Click to expand...


.
Click to expand...
 
MySundayDate: DateAdd("d", 1 - DatePart("w", [PLANNED_START_DATE], 1),
[PLANNED_START_DATE])


--

Ken Snell
<MS ACCESS MVP>


Mary said:
I'm running a query on all activities for July by week. We
want to have a field that shows the date for the Sunday of
that week. The field it's pulling from is
[PLANNED_START_DATE]. Each activity has a planned start
date. The query should have a field that populates with
the Sunday date associated with the planned start date so
I can sort on that field. We'll always want the Sunday of
the week the planned start date falls in. Does that help?
-----Original Message-----
? Pull the Sunday date? Can you give us more info? Example data in the table
and example data that should display?

--

Ken Snell
<MS ACCESS MVP>

I'd like to pull the Sunday date for my
[PLANNED_START_DATE] field. Can you help with the format
statement - I can't get it to work.

Thanks!
Mary
Click to expand...


.
Click to expand...
Click to expand...
 
Worked like a charm. Thanks!!!
-----Original Message-----
MySundayDate: DateAdd("d", 1 - DatePart("w", [PLANNED_START_DATE], 1),
[PLANNED_START_DATE])


--

Ken Snell
<MS ACCESS MVP>


I'm running a query on all activities for July by week. We
want to have a field that shows the date for the Sunday of
that week. The field it's pulling from is
[PLANNED_START_DATE]. Each activity has a planned start
date. The query should have a field that populates with
the Sunday date associated with the planned start date so
I can sort on that field. We'll always want the Sunday of
the week the planned start date falls in. Does that help?
-----Original Message-----
? Pull the Sunday date? Can you give us more info? Example data in the table
and example data that should display?

--

Ken Snell
<MS ACCESS MVP>

I'd like to pull the Sunday date for my
[PLANNED_START_DATE] field. Can you help with the format
statement - I can't get it to work.

Thanks!
Mary


.
Click to expand...
Click to expand...


.
Click to expand...
 
You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Mary said:
Worked like a charm. Thanks!!!
-----Original Message-----
MySundayDate: DateAdd("d", 1 - DatePart("w", [PLANNED_START_DATE], 1),
[PLANNED_START_DATE])


--

Ken Snell
<MS ACCESS MVP>


I'm running a query on all activities for July by week. We
want to have a field that shows the date for the Sunday of
that week. The field it's pulling from is
[PLANNED_START_DATE]. Each activity has a planned start
date. The query should have a field that populates with
the Sunday date associated with the planned start date so
I can sort on that field. We'll always want the Sunday of
the week the planned start date falls in. Does that help?

-----Original Message-----
? Pull the Sunday date? Can you give us more info?
Example data in the table
and example data that should display?

--

Ken Snell
<MS ACCESS MVP>

message
I'd like to pull the Sunday date for my
[PLANNED_START_DATE] field. Can you help with the
format
statement - I can't get it to work.

Thanks!
Mary


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top