how to get pre date and post date

[sagarrahul]

Considerations-

1) covernote Number and Issue Date are coming in-line with Each Other & In Mentioned Sequence.

2) Data Arrives in Ascending Order of Issue_Date

Pseudo-Code

1) Split Issue_Date Column. Capture Month & Date into two Difference Array Variables/Dataset (as Preferred)

date_array1[]= issue_date.split(1)

month_array2[]=issue_date.split(2)

2) Store CovenantNo into another array

covenant_no_array3[]= loop(Covenant Number)

3) Apply Bubble Sort (Quick Sort Can also be done for Faster Results, but Bubble Sort will be easy to identify out of Order Value.)-

a. First on month_array2[] (use as outer loop)

b. Second on date_array1[] (use as inner loop)

4) When out of Order Value found, print that value as Current Value. Pre-Value is index-1 of Current Value. Post Value is index+1 of current value. Covenant number is index of current value,

used in covenant_no array

i.e.

current_value= date_array1

pre_value= date_array1[i-1]

post_value= date_array1[i+1]

covenant_no=covenant_no_array3

how to do it in script and expression

can u help me in dis

[#2]

HI sagar

you can try this in sorting tab

Sort by expression (Ascending):

=Date#(Day&Month&Year, 'DDMMMYYYY')

[sagarrahul]

ty sir for giving ur time

i m having certain  covernote_number  and pol_issue_date.

as in this table

covernote number	pol_issue_date
2302168904	18-Nov-2014
2302168905	18-Nov-2014
2302168908	18-Nov-2014
2302168910	19-Nov-2014
2302168915	20-Nov-2014
2302168931	20-Nov-2014
2302168934	11-Nov-2014
2302168940	21-Nov-2014
2302168945	22-Nov-2014
2302168946	22-Nov-2014

sir this date table is in proper ascending order .

bt my problem comes when date i.e. pol_issue_date is not in proper order .

will gv u example : 

COVERNOTE_NUMBER	POL_ISSUE_DATE
2302168701	16-Oct-2014
2302168715	29-Nov-2014
2302168717	28-Nov-2014
2302168718	26-Nov-2014
2302168720	28-Nov-2014
2302168721	19-Nov-2014

sir look at this :

first covernote_number is 2302168701 and its pol_issue date is 16\oct\2014

(in this both covernote_number and pol_issue_date is correct in sequences )

second covernote_number is 2302168715 and its pol_issue date is 29\nov\2014

(in this covernote_number and pol_issue_date is correct as its upper date is of oct month and this date is nov so it correct )

third covernote_number is 2302168707 and its pol_issue date is 28\nov\2014

(in this covernote_number is right and pol_issue_date is not in order date is 28-nov-2014 from above date is bigger that is 29\nov\2014 month )

as

as all the rest are in not order

so i want the output in dis way

all the pol_issue date which are not in order it should through this output as below

COVERNOTE_NUMBER	POL_ISSUE_DATE
	29-Nov-2014
2302168717	28-Nov-2014
	26-Nov-2014