date isseus

dnowebdn — Tue, 08 Jan 2019 11:40:45 GMT

Date issue

Re: start date and end date

shiveshsingh — Tue, 08 Jan 2019 10:05:16 GMT

Try this

F:
load Pointer, Date(Finish,'DD/MM/YYYY') as Finish, Date(Start,'DD/MM/YYYY') as Start, 1 as flag;

LOAD * INLINE [

Pointer, Finish, Start
1A, 2018-03-25 17:00:00.000, 2018-03-03
1A, 2018-03-26 01:00:00.000, 2018-03-05
1A, 2018-03-27 19:00:00.000, 2018-03-03
1A, -, -
1B, 2018-03-25 17:00:00.000, 2018-03-05
1B, -, -
2B, 2018-03-25 17:00:00.000, 2018-03-05
3A, 2018-03-21 22:40:00.000, 2018-03-03
4A, -, -
5A, 2018-03-21 22:40:00.000, 2018-03-09
5A, 2018-03-22 12:00:00.000, 2018-03-11
5A, 2018-03-25 17:00:00.000, 2018-03-05
5A, 2018-03-26 01:00:00.000, 2018-03-05
5A, 2018-03-27 23:00:00.000, 2018-03-05
5A, -, -
5B, 2018-03-26 01:00:00.000, 2018-03-05
5B, -, -
Common, -, -
1, -, -
6, 2018-03-25 17:00:00.000, 2018-03-03
6, 2018-03-25 17:00:00.000, 2018-03-05
6, -, -
];

Final_T:

load Date(min(Start)),Date(Max(Finish)),Pointer
Resident F
group by Pointer;

drop table F;

topic Re: start date and end date in App Development

date isseus

Re: start date and end date