Date1 = 2021-01-22 11:43:38.000
Date2 = 2021-01-22 14:32:38.000
how we check duration of time between two dates through vbscript
result should be HH:MM:SS
Loading
10 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
where you comparing the dates and where did you assign can u show me clearly
format the output as
- >> secs = 308
- >> ts = TimeSerial(0, 0, secs)
- >> WScript.Echo FormatDateTime(ts, vbLongTime)
- >>
- 00:05:08
unable to understand sorry
Again you can format output as
- >> secs = 308
- >> ts = TimeSerial(0, 0, secs)
- >> WScript.Echo FormatDateTime(ts, vbLongTime)
- >>
- 00:05:08
ouput should be
HH:MM:SS
and stored in variable
DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])
Examples:
- Date1 = "31-Jan-09 00:00:00"
- Date2 = "31-Jan-10 23:59:00"
- response.write(DateDiff("yyyy",Date1,Date2) & "
- response.write(DateDiff("q",Date1,Date2) & "
- response.write(DateDiff("m",Date1,Date2) & "
- response.write(DateDiff("y",Date1,Date2) & "
- response.write(DateDiff("d",Date1,Date2) & "
- response.write(DateDiff("w",Date1,Date2) & "
- response.write(DateDiff("ww",Date1,Date2) & "
- response.write(DateDiff("h",Date1,Date2) & "
- response.write(DateDiff("n",Date1,Date2) & "
- response.write(DateDiff("s",Date1,Date2) & "
- 1
- 4
- 12
- 365
- 365
- 52
- 53
- 8783
- 527039
- 31622340
Rajanikant HawaldarPosted Jan 26, 2021, 2:23 PM
Jhon ABhuPosted Jan 25, 2021, 8:14 PM
Jhon ABhuPosted Jan 25, 2021, 6:55 PM
Rijwan AnsariPosted Jan 25, 2021, 6:39 PM