Hi Everyone,
I have vacation tracker for +200 employee, my boss asked me question to sort by (DATE) current date see table below:
He wants to be able to see the most recent day on the top of the column... example today is 29, he want the first employee to show from date 29April until 19 Jun (see below) and then from 23Apr till 28 April on the bottom...
Any idea?
[TABLE="width: 319"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 4"]DEPARTURE[/TD]
[/TR]
[TR]
[TD]DATE[/TD]
[TD]TIME[/TD]
[TD]AIRLINE[/TD]
[TD]FLIGHT NO.[/TD]
[/TR]
[TR]
[TD]23-Apr-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]24-Apr-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]8.50 AM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 5302[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]8.50 AM[/TD]
[TD]Emirates[/TD]
[TD]FZ 5302[/TD]
[/TR]
[TR]
[TD]28-Apr-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]29-Apr-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]01-May-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]03-May-19[/TD]
[TD]2.40 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 5304[/TD]
[/TR]
[TR]
[TD]04-May-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]05-May-19[/TD]
[TD]8:25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]08-May-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]09-May-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]09-May-19[/TD]
[TD]11.40 AM[/TD]
[TD]Hahn Air Sytem[/TD]
[TD]H1 9013[/TD]
[/TR]
[TR]
[TD]10-May-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]11-May-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]11-May-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]21-May-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]31-May-19[/TD]
[TD]8:50 AM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0302[/TD]
[/TR]
[TR]
[TD]13-Jun-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]19-Jun-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
</tbody>[/TABLE]
I have vacation tracker for +200 employee, my boss asked me question to sort by (DATE) current date see table below:
He wants to be able to see the most recent day on the top of the column... example today is 29, he want the first employee to show from date 29April until 19 Jun (see below) and then from 23Apr till 28 April on the bottom...
Any idea?
[TABLE="width: 319"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 4"]DEPARTURE[/TD]
[/TR]
[TR]
[TD]DATE[/TD]
[TD]TIME[/TD]
[TD]AIRLINE[/TD]
[TD]FLIGHT NO.[/TD]
[/TR]
[TR]
[TD]23-Apr-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]24-Apr-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]8.50 AM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 5302[/TD]
[/TR]
[TR]
[TD]25-Apr-19[/TD]
[TD]8.50 AM[/TD]
[TD]Emirates[/TD]
[TD]FZ 5302[/TD]
[/TR]
[TR]
[TD]28-Apr-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]29-Apr-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]01-May-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]03-May-19[/TD]
[TD]2.40 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 5304[/TD]
[/TR]
[TR]
[TD]04-May-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]05-May-19[/TD]
[TD]8:25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]08-May-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]09-May-19[/TD]
[TD]6.15 PM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0306[/TD]
[/TR]
[TR]
[TD]09-May-19[/TD]
[TD]11.40 AM[/TD]
[TD]Hahn Air Sytem[/TD]
[TD]H1 9013[/TD]
[/TR]
[TR]
[TD]10-May-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]11-May-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]11-May-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
[TR]
[TD]21-May-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]31-May-19[/TD]
[TD]8:50 AM[/TD]
[TD]Fly Dubai[/TD]
[TD]FZ 0302[/TD]
[/TR]
[TR]
[TD]13-Jun-19[/TD]
[TD]8.25 AM[/TD]
[TD]Turkish Airlines[/TD]
[TD]TK 0707[/TD]
[/TR]
[TR]
[TD]19-Jun-19[/TD]
[TD]4.20 PM[/TD]
[TD]Emirates[/TD]
[TD]EK 0641[/TD]
[/TR]
</tbody>[/TABLE]