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
    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
    Can Guru Sahib change our 'bhaag' (destiny/fortune) or we have to live with it ? is it fixed Sikh Sikhi Sikhism Oct 8, 2015

  3. 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.
     

Share This Page