DateAdd 1st day in Week ?

[john]

I got this off a group and it works in a crosstab query to group hours
worked from Sunday thru Saturday into a total hours for the week.

My question is, what does the minus sign do in front of the Weekday
function; is it a switch that cause it to collapse the date into a single
column? Having no sign or a + sign returns a different but same result if
there is no sign or a + sign, neither returns a single column for the week.

DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])

Thanks John

 

[ruralguy via AccessMonster.com]

DateAdd() can subtract from a date as well as add. Have you tried removing
the minus sign to see what it does to the results?

I got this off a group and it works in a crosstab query to group hours
worked from Sunday thru Saturday into a total hours for the week.

My question is, what does the minus sign do in front of the Weekday
function; is it a switch that cause it to collapse the date into a single
column? Having no sign or a + sign returns a different but same result if
there is no sign or a + sign, neither returns a single column for the week.

DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])

Thanks John

 

[john]

Yes, that what Iwas saying in the 2nd part of my question, it does not
appear to act as a math function, more like the + & - on the file system,
except it collapses or sums the hours of a week into one column with the -
sign, but not without it.

john

DateAdd() can subtract from a date as well as add. Have you tried
removing
the minus sign to see what it does to the results?

I got this off a group and it works in a crosstab query to group hours
worked from Sunday thru Saturday into a total hours for the week.

My question is, what does the minus sign do in front of the Weekday
function; is it a switch that cause it to collapse the date into a single
column? Having no sign or a + sign returns a different but same result if
there is no sign or a + sign, neither returns a single column for the
week.

DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])

Thanks John

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[ruralguy via AccessMonster.com]

The function you posted returns the [DateWorked] date adjusted to the
previous Sunday's date.

Yes, that what Iwas saying in the 2nd part of my question, it does not
appear to act as a math function, more like the + & - on the file system,
except it collapses or sums the hours of a week into one column with the -
sign, but not without it.

john

DateAdd() can subtract from a date as well as add. Have you tried
removing

[quoted text clipped - 12 lines]

 

[Charles Wang[MSFT]]

Hi John,
The minus sign just means past date here and mathmatically substraction.
For your expression:
DateAdd("w",-Weekday([DateWorked],1)+1,[DateWorked])
The return value of Weekday is substracted by 1. If the result is minus and
the value is N, the DateAdd expression means that get the date of the past
N days of the current date. In this case, it has the same result as 'd'.

Could you please let us know what your exact requirement is?
If you have any other questions or concerns, please feel free to let me
know.
Have a good day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

 

[Charles Wang[MSFT]]

Hi John,
How about this issue? If you need further assistance, please feel free to
post back.

Have a good day!

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================