unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hi Guys,
Can you possibly help me of how to code for this scenario:
Basically, I need to exclude the data not older than 4 years. However for the computation, the start date is not based from the current date but I want to set the date so a message box will pop asking me what is the starting date for computation.
<tbody>
</tbody>
Result: Exclude Data More than 4 Years
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 115.764px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>Any thoughts will be much appreciated.
Can you possibly help me of how to code for this scenario:
Basically, I need to exclude the data not older than 4 years. However for the computation, the start date is not based from the current date but I want to set the date so a message box will pop asking me what is the starting date for computation.
Code | Name | Qty | Date | Source |
001 | Ben | 500 | 05/01/2010 | Book 1 |
002 | Len | 150 | 05/01/2019 | Book 5 |
003 | Sean | 100 | 05/01/2018 | Book 4 |
004 | Roan | 350 | 05/01/2013 | Book 1 |
<tbody>
</tbody>
Result: Exclude Data More than 4 Years
Code | Name | Qty | Date | Source |
002 | Len | 150 | 05/01/2019 | Book 5 |
003 | Sean | 100 | 05/01/2018 | Book 4 |
Excluded | ||||
001 | Ben | 500 | 05/01/2010 | Book 1 |
004 | Roan | 350 | 05/01/2013 | Book 1 |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 115.764px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
Book 1 |
<tbody>
</tbody>