Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have two column as time and defect id.The defect id has different time and date.i need to show the start date and end date of defect id.
if there are different defect id for each defect id i need to calculate the start and end date
defect id time
1 014-05-26 22:41:34
2 2014-05-28 05:59:11
1 2014-05-30 02:37:04
2 2014-05-26 00:07:52
1 2014-05-26 15:37:14
2 2014-05-26 22:41:34
3 2014-05-28 05:59:11
3 2014-05-30 02:37:04
etc
i need is:
defect id time start date end date
1 014-05-26 22:41:34 014-05-26 22:41:34 2014-05-30 02:37:04
2 2014-05-28 05:59:11 2014-05-28 05:59:11 2014-05-26 00:07:52
1 2014-05-30 02:37:04 2014-05-30 02:37:04 2014-05-26 15:37:14
2 2014-05-26 00:07:52 2014-05-26 00:07:52 2014-05-26 22:41:34
1 2014-05-26 15:37:14 2014-05-26 15:37:14 todays date
2 2014-05-26 22:41:34 2014-05-26 22:41:34 today date
3 2014-05-28 05:59:11 2014-05-28 05:59:11 2014-05-30 02:37:04
3 2014-05-30 02:37:04 2014-05-30 02:37:04 today date
if i will put filter on defect id say 1 is selected then it will show :
defect id time startdate end date
1 014-05-26 22:41:34 014-05-26 22:41:34 2014-05-30 02:37:04
1 2014-05-30 02:37:04 2014-05-30 02:37:04 2014-05-26 15:37:14
1 2014-05-26 15:37:14 2014-05-26 15:37:14 todays date
Change only one line
IF([defect id] = Previous([defect id]),Previous(time),Date(Today())) as EndDate,
IF([defect id] = Previous([defect id]),Previous(time),Date(Today(),'YYYY-MM-DD') as EndDate,
no still it i not coming correct
Let me have your QVW file please..
hi please find the attached qvw file .
QVW file please !
i have already shared the qvw file please check first discussion page
hi manish,
did you get the qvw file?