473,407 Members | 2,306 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

get start date and end date sequence

Posted - 03/29/2011 : 06:34:20
I have a table which contain Topic, Sequence number and no of turns.
User input the Single Start date and on the basis of which
series of start date and end date is calculated.

Let start date= 1 Jan ,2011
then

Topic | Sequence number |NoOfTurns | Start date | end date
.................................................. ....................
Theorem | 1 | 5 | 1 jan,2011 | 6 jan,2011
circle | 2 | 4 | 7 jan,2011 | 11 jan,2011
triangle | 3 | 4 | 12 jan,2011 | 15 jan,2011



Start date is the End date of upper row and End date = Startdate + no of turns as days.

Please help me to get start date and end date sequence
Mar 29 '11 #1
1 2167
Rabbit
12,516 Expert Mod 8TB
You can use a max on the end date for the new start date. And then a dateadd to get the end date. But be aware that 1/1/2011 - 1/6/2011 is a range of 6 days, not 5.
Mar 29 '11 #2

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

Similar topics

0
by: Gernot Saborowski | last post by:
To all IIS/ASP-professionals, we just upgraded from one machine to another and are experiencing some strange date time number problems. Both systems have been set up like this: - MS Windows...
1
by: Monica Roman | last post by:
Hello, help please. I have a little macro that copies the date from a date/time field to a memo field, BUT instead of going to the memo field it finds the first date/time field and tries to copy...
1
by: AvrilComplic8ed | last post by:
Hello there I wonder if you can help me. I am creating a loans system for a make-believe CD rental company, in Microsoft Access. I have 3 tables: CD details, Member Details, and Loan Details. I...
36
by: MLH | last post by:
Does Date = Date + 1 mean Date Statement equals Date Function plus 1? And if the answer is Yes, how much actual time is being added to the date function in this assignment?
1
by: Nick Chan | last post by:
Hello, How do I get the start date, and end date of a given week example, Week 20, year 2004.
1
by: Me | last post by:
I need to get the past 5(x) months for certaing calculations. What I have is listed below: ######################################## my $year, $month_str, $month_int; foreach my $count...
9
by: Millie18 | last post by:
Hi, I’m trying to set up a query to find all dates on or between a start and end date. Table name and field names I’ve used: Tbl_bookings Booking No Boarding Arrival Date Boarding Departure...
3
by: lyndac | last post by:
Hello! Last night a job to create a view using DATE(CURRENT DATE - 1 DAY) received the current days date instead the previous days date. Any one know why/how this can happen? The...
1
by: dkyadav80 | last post by:
hi sir, I have following problem: code goes here: {code] 1. <html> 2. <body>
3
by: viditsinghal | last post by:
I need to write a C++ function that takes date as input and return day of the week as output. Can i get it somewhere where all the possiblibilies are covered. -Regards VS
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.