date problem

**woundedcrane** · 02-10-2015, 03:12 AM

0B0025 9/6/2015 22/1/2015
4U0614 2/5/2015 31/1/2015
4U0614 9/5/2015 28/2/2015
4U0614 19/5/2015 31/3/2015
4U0614 24/10/2015 30/4/2015
4U2618 2/5/2015 31/5/2015
hello everyone i have the above data set
and i want to create the dates for each row from the starting date till the the end date like below (7days step )
0B0025 9/6/2015 22/1/2015
0B0025 16/6/2015 23/1/2015
0B0025 23/6/2015 24/1/2015
0B0025 30/6/2015 25/1/2015
0B0025 7/7/2015 26/1/2015
0B0025 14/7/2015 27/1/2015
0B0025 21/7/2015 28/1/2015
0B0025 28/7/2015 29/1/2015
0B0025 4/8/2015 30/1/2015
0B0025 11/8/2015 31/1/2015
0B0025 18/8/2015 1/2/2015
0B0025 25/8/2015 2/2/2015
0B0025 1/9/2015 3/2/2015
0B0025 8/9/2015 4/2/2015
0B0025 15/9/2015 5/2/2015
0B0025 22/9/2015 6/2/2015
0B0025 9/6/2015 22/1/2015
4U0614 2/5/2015 31/1/2015
any help ?

**Special-K** · 02-10-2015, 06:50 AM

Why is this

0B0025 9/6/2015 22/1/2015

repeated in the column? Do you actually want it to appear twice?

I would expect the start date to be first then the end date but it looks like end date is first, can you confirm this?

The dates dont make sense.
Column 2 has dates stepping in steps of 7, column 3 has dates stepping in steps of 1.
But then the dates stop for no reason at all and the new reference starts up.
Why does the 0B0025 sequence suddenly stop?

**woundedcrane** · 02-11-2015, 03:34 AM

hello ,
i have writen the data the follwing lines is what i have
starting date end date
0B0025 9/6/2015 22/9/2015
4U0614 9/5/2015 17/10/2015
and the following what i need to create with 7 step days
after the 7 step
starting date
0B0025 9/6/2015
0B0025 16/6/2015
0B0025 23/6/2015
0B0025 30/6/2015
0B0025 7/7/2015
0B0025 14/7/2015
0B0025 21/7/2015
0B0025 28/7/2015
0B0025 4/8/2015
0B0025 11/8/2015
0B0025 18/8/2015
0B0025 25/8/2015
0B0025 1/9/2015
0B0025 8/9/2015
0B0025 15/9/2015
0B0025 22/9/2015
4U0614 9/5/2015
etc
after i reach the end date for 0B0025 the next code begins and i need to do the same procedure and so on cause i have 20.000 lines

**FDibbins** · 02-11-2015, 03:34 AM

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

date problem

LinkBack

Thread Tools

Rate This Thread

Display

date problem

Re: date problem

Re: date problem

Re: date problem

Thread Information

Users Browsing this Thread

Similar Threads

Advanced filter by date range, international date format problem

[SOLVED] Problem with engaging an ERROR based on a date being <= another date

Date and day problem

3 columns; date and two data, problem is sorting and calculating with respect to date

[SOLVED] Date Problem's

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions