Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Change The Start And End Hours In A Date

Discussion in 'Information Technology' started by Don, Oct 30, 2005.

  1. Don

    Don
    Expand Collapse
    Guest

    Criteria in a query:
    I need to calculate days using 07:00 as the start of day and 07:00 (next
    day) as the end of day.
    Specifically to calculate sales in a Pub where sales may exceed 24:00 and
    not exceed 07:00 the next day
     
  2. Loading...

    Similar Threads Forum Date
    Change Starts Within - Dalai Lama Spiritual Articles Oct 29, 2007
    Can Sikhi Be Relevant In The Modern World As A Driver For Social Change? Blogs Feb 22, 2017
    Interfaith A Sikh Change Comes To Houston’s Finest Interfaith Dialogues Mar 3, 2016
    Angry Exchanges With Christians Blogs Oct 17, 2015
    Day 1-Forever Changes, Love Blogs Oct 17, 2015

  3. OP
    RuralGuy

    RuralGuy
    Expand Collapse
    Guest

    You can use DateAdd("h",-7,[YourTimeField]) to adjust your records by -7 hours.
    On Sat, 29 Oct 2005 12:40:05 -0700, Don <Don@discussions.microsoft.com> wrote:

    >Criteria in a query:
    >I need to calculate days using 07:00 as the start of day and 07:00 (next
    >day) as the end of day.
    >Specifically to calculate sales in a Pub where sales may exceed 24:00 and
    >not exceed 07:00 the next day

    _______________________________________________
    hth - RuralGuy (RG for short)
    Please post to the NewsGroup so all may benefit.
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page