time1$ = '1391/05/07'
time2$ = '1392/01/25'
y1 = VAL(StrCopy(time1$,1,4))*365
m1 = VAL(StrCopy(time1$,6,2)) - 1
If (m1<1) Then
m1 = 12
End
If (m1<=6 & m1>1) Then
m1 = m1*31
Else
m1 = m1*30
End
d1 = VAL(StrCopy(time1$,9,2))
time1 = y1 + m1 + d1
***********
y2 = VAL(StrCopy(time2$,1,4))*365
m2 = VAL(StrCopy(time2$,6,2)) - 1
If (m2<1) Then
m2 = 12
End
If (m2<=6 & m2>1) Then
m2 = m2*31
Else
m2 = m2*30
End
d2 = VAL(StrCopy(time2$,9,2))
time2 = y2 + m2 + d2
***********
difference = time2 - time1
Message("","difference")
دوست عزيز
پيشنهاد ميكنم هر تاريخ رو به طور مجزا به تعداد روزهاي گذشته تبديل كنيد و بعد از حاصر كسر دو عدد نسبت به هم اختلاف روزها رو بدست بياريد.
کد:time1$ = '1391/05/07' time2$ = '1392/01/25' y1 = VAL(StrCopy(time1$,1,4))*365 m1 = VAL(StrCopy(time1$,6,2)) - 1 If (m1<1) Then m1 = 12 End If (m1<=6 & m1>1) Then m1 = m1*31 Else m1 = m1*30 End d1 = VAL(StrCopy(time1$,9,2)) time1 = y1 + m1 + d1 *********** y2 = VAL(StrCopy(time2$,1,4))*365 m2 = VAL(StrCopy(time2$,6,2)) - 1 If (m2<1) Then m2 = 12 End If (m2<=6 & m2>1) Then m2 = m2*31 Else m2 = m2*30 End d2 = VAL(StrCopy(time2$,9,2)) time2 = y2 + m2 + d2 *********** difference = time2 - time1 Message("","difference")
time1$ = [COLOR=#800000]'1391/5/07'[/COLOR]
time2$ = [COLOR=#800000]'1392/01/25'[/COLOR]
[COLOR=#009000]***********************************************************[/COLOR]
Delimiter$ = [COLOR=#800000]'/'[/COLOR]
time1$ = time1$ + Delimiter$
time2$ = time2$ + Delimiter$
y1 = [COLOR=#000090][B]VAL[/B][/COLOR]([COLOR=#000090][B]GetArrayItem[/B][/COLOR](time1$,Delimiter$,[COLOR=#ff0000]1[/COLOR]))*[COLOR=#ff0000]365[/COLOR]
m1 = [COLOR=#000090][B]VAL[/B][/COLOR]([COLOR=#000090][B]GetArrayItem[/B][/COLOR](time1$,Delimiter$,[COLOR=#ff0000]2[/COLOR])) - [COLOR=#ff0000]1[/COLOR]
[COLOR=#0000FF]If[/COLOR] (m1<[COLOR=#ff0000]1[/COLOR]) [COLOR=#0000FF]Then[/COLOR]
m1 = [COLOR=#ff0000]12[/COLOR]
[COLOR=#0000FF]End[/COLOR]
[COLOR=#0000FF]If[/COLOR] (m1<=[COLOR=#ff0000]6[/COLOR] & m1>[COLOR=#ff0000]1[/COLOR]) [COLOR=#0000FF]Then[/COLOR]
m1 = m1*[COLOR=#ff0000]31[/COLOR]
[COLOR=#0000FF]Else[/COLOR]
m1 = m1*[COLOR=#ff0000]30[/COLOR]
[COLOR=#0000FF]End[/COLOR]
d1 = [COLOR=#000090][B]VAL[/B][/COLOR]([COLOR=#000090][B]GetArrayItem[/B][/COLOR](time1$,Delimiter$,[COLOR=#ff0000]3[/COLOR]))
time1 = y1 + m1 + d1
[COLOR=#009000]***********[/COLOR]
y2 = [COLOR=#000090][B]VAL[/B][/COLOR]([COLOR=#000090][B]GetArrayItem[/B][/COLOR](time2$,Delimiter$,[COLOR=#ff0000]1[/COLOR]))*[COLOR=#ff0000]365[/COLOR]
m2 = [COLOR=#000090][B]VAL[/B][/COLOR]([COLOR=#000090][B]GetArrayItem[/B][/COLOR](time2$,Delimiter$,[COLOR=#ff0000]2[/COLOR])) - [COLOR=#ff0000]1[/COLOR]
[COLOR=#0000FF]If[/COLOR] (m2<[COLOR=#ff0000]1[/COLOR]) [COLOR=#0000FF]Then[/COLOR]
m2 = [COLOR=#ff0000]12[/COLOR]
[COLOR=#0000FF]End[/COLOR]
[COLOR=#0000FF]If[/COLOR] (m2<=[COLOR=#ff0000]6[/COLOR] & m2>[COLOR=#ff0000]1[/COLOR]) [COLOR=#0000FF]Then[/COLOR]
m2 = m2*[COLOR=#ff0000]31[/COLOR]
[COLOR=#0000FF]Else[/COLOR]
m2 = m2*[COLOR=#ff0000]30[/COLOR]
[COLOR=#0000FF]End[/COLOR]
d2 = [COLOR=#000090][B]VAL[/B][/COLOR]([COLOR=#000090][B]GetArrayItem[/B][/COLOR](time2$,Delimiter$,[COLOR=#ff0000]3[/COLOR]))
time2 = y2 + m2 + d2
[COLOR=#009000]***********[/COLOR]
difference = time2 - time1
[COLOR=#000090][B]Message[/B][/COLOR]("","difference")
time1$ = '1391/5/7'
time2$ = '1392/1/25'
****
time1$ = '1391/5/07'
time2$ = '1392/01/25'
****
time1$ = '91/5/07'
time2$ = '92/01/25'
****
time1$ = '91/5/7'
time2$ = '92/1/25'
****
time1$ = '91/05/07'
time2$ = '92/01/25'
[/COLOR][COLOR=#0000FF]If[/COLOR][COLOR=#333333] (m2<=[/COLOR][COLOR=#ff0000]6[/COLOR][COLOR=#333333] & m2>[/COLOR][COLOR=#ff0000]1[/COLOR][COLOR=#333333]) [/COLOR][COLOR=#0000FF]Then ==> [/COLOR][COLOR=#0000FF]If[/COLOR][COLOR=#333333] (m2<=[/COLOR][COLOR=#ff0000]6[/COLOR][COLOR=#333333] & m2>[/COLOR][COLOR=#000080][B]=[/B][/COLOR][COLOR=#333333][/COLOR][COLOR=#ff0000]1[/COLOR][COLOR=#333333]) [/COLOR][COLOR=#0000FF]Then[/COLOR][COLOR=#333333]