Forum Discussion
Consecutive dates
I am having an issue with my report, I have a table with a reference and start date (the earliest date is the start date and the latest date is the end date), Reference numbers are duplicated with different start and end dates, the report is working for those have a consecutive date but for those having the gap between start and end date is not working correctly) I want to show them in a different row if there is a gap between the start and end dates.
5 Replies
Hi,
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result clearly.
Hi Ashish,
Data
Id M ARMS Ref Start D/T 562455 AO-PR-22-000871 11/10/2022 1:30:00 AM 562455 AO-PR-22-000871 13/10/2022 1:30:00 AM 548988 AO-PR-22-000841 10/12/2022 12:00:00 AM 548988 AO-PR-22-000841 10/12/2022 1:30:00 AM 548988 AO-PR-22-000841 11/12/2022 12:00:00 AM 548988 AO-PR-22-000841 12/12/2022 12:00:00 AM 542031 AO-PR-22-000813 24/10/2022 1:30:00 AM 542031 AO-PR-22-000813 25/10/2022 1:30:00 AM 542031 AO-PR-22-000813 26/10/2022 1:30:00 AM 542031 AO-PR-22-000813 27/10/2022 1:30:00 AM 542031 AO-PR-22-000813 28/10/2022 1:30:00 AM 541821 AO-PR-22-000812 31/08/2022 9:00:00 PM 467841 AO-PR-22-000219 07/11/2022 9:00:00 PM 467841 AO-PR-22-000219 08/11/2022 9:00:00 PM 467841 AO-PR-22-000219 09/11/2022 9:00:00 PM 467841 AO-PR-22-000219 10/11/2022 9:00:00 PM 455821 AO-PR-22-000181 10/12/2022 12:00:00 AM 455821 AO-PR-22-000181 10/12/2022 1:30:00 AM 455821 AO-PR-22-000181 11/12/2022 12:00:00 AM 455821 AO-PR-22-000181 12/12/2022 12:00:00 AM 429216 AO-PR-22-000132 26/11/2022 9:00:00 PM 429216 AO-PR-22-000132 27/11/2022 9:00:00 PM Result
M ARMS Ref Start Date Start Time Finish Date Finish Time AO-PR-22-000132 Sat, 26 Nov 22 21:00 Mon, 28 Nov 22 4:00 AO-PR-22-000181 Sat, 10 Dec 22 1:30 Mon, 12 Dec 22 3:00 AO-PR-22-000219
(4no)Mon, 7 Nov 22 21:00 Fri, 11 Nov 22 4:00 AO-PR-22-000812 Wed, 31 Aug 22 21:00 Thu, 1 Sep 22 4:00 AO-PR-22-000813 Mon, 24 Oct 22 1:30 Fri, 28 Oct 22 4:00 AO-PR-22-000841 Sat, 10 Dec 22 1:30 Mon, 12 Dec 22 3:00 AO-PR-22-000871 Tue, 11 Oct 22 1:30 Tue, 11 Oct 22 4:00 AO-PR-22-000871 Thu, 13 Oct 22 1:30 Thu, 13 Oct 22 4:00