By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,153 Members | 2,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,153 IT Pros & Developers. It's quick & easy.

Default Start of Day Time

P: 7
Hi,

I am looking for some help with an MS Access query.

I need to change my start of day time from the default 00:00 to 06:00.

Is there any way to do this in a query? I am using the below text in my query to show data for last week with the week being Monday-Monday.

Field = Week: DatePart("ww",[Receipt_Date_Time],2)
Criteria = Format(Now(),"ww")-1

This works but I need my week to be Monday 6am - Sunday 5:59:59am or ideally I would like to pull these times from a table.

Any help would be greatly appreciated.
Aug 20 '08 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,616
This makes little sense to me.

DateAdd() can move the date value by 6 hours if you need, but your question seems to want to change Monday - Monday to Monday 06:00 to Sunday 06:00.

Suddenly the time between Sunday 06:00 and Monday 06:00 just disappears :S

When you have the requirement clear, check out the documentation for DateAdd(). I expect it will provide what you need.
Aug 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.