DateDiff Function
æćźăăă 2 ă€ăźæ„ä»ć€ăźéăźæ„ä»ééăźæ°ăèżăăŸăă
æ§æ:
DateDiff (Add, Date1, Date2 [, Week_start [, Year_start]])
æ»ăć€:
æ°ć€ă
ăă©ăĄăŒăżăŒ:
Add - æ„ä»ăźééăæćźăăăćŸç¶ăźăăŒăă«ăăăźæćććŒă
Date1, Date2 - æŻèŒăă 2 ă€ăźæ„ä»ć€ă
Week_start - é±ăźéć§ææ„ăæćźăăăȘăă·ă§ăłăźăă©ăĄăŒăżăŒă
Week_start 〠|
èȘŹæ |
0 |
ă·ăčăă ăźăăă©ă«ăć€ăäœżçš |
1 |
æ„ææ„ (ăăă©ă«ă) |
2 |
æææ„ |
3 |
ç«ææ„ |
4 |
æ°Žææ„ |
5 |
æšææ„ |
6 |
éææ„ |
7 |
ćææ„ |
Year_start - ćčŽăźéć§é±ăæćźăăăȘăă·ă§ăłăźăă©ăĄăŒăżăŒă
Year_start 〠|
èȘŹæ |
0 |
ă·ăčăă ăźăăă©ă«ăć€ăäœżçš |
1 |
Week 1 㯠1 æ 1 æ„ăć«ăé± (ăăă©ă«ă) |
2 |
Week 1 ăŻăăăźćčŽăź 4 æ„仄äžăć«ăæćăźé± |
3 |
Week 1 ăŻăæ°ćčŽăźæ„ä»ăźăżăć«ăæćăźé± |
äŸ:
Sub example_datediff
MsgBox DateDiff("d", "1/1/2005", "12/31/2005")
End Sub