If I have a table as below:
| ClinicID | Visited Date |
| 001 | 23Feb2021 |
| 002 | 15Apr2021 |
| 003 | 11Jun2021 |
| 004 | 7Dec2021 |
| 005 | 7Jul2021 |
| 006 | 9Jan2021 |
| 007 | 10Sep2021 |
| 008 | 2Aug2021 |
| 009 | 7Jan2021 |
| 010 | 19Mar2021 |
How can I calculate number of days from these dates to the end of its quarter?
Outcome would be like a table as below:
| Clinic ID | Visited Date | N days |
| 004 | 7Dec2021 | 24 |
Sophon
0 Response to Calculate number of days from selected date to the end of quarter
Post a Comment