VBScript duration check between two dates

Question

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

Rijwan Ansari · Answer

Date1 = "31-Jan-09 00:00:00" Date2 = "31-Jan-10 23:59:00" secValue = DateDiff( "s" ,Date1,Date2) ts = TimeSerial(0, 0, secValue) finalOutput = FormatDateTime(ts, vbLongTime) Try this

Rijwan Ansari · Answer

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) & " " ) Output 1 4 12 365 365 52 53 8783 527039 31622340

Rijwan Ansari · Answer

format the output as >> secs = 308 >> ts = TimeSerial(0, 0, secs) >> WScript.Echo FormatDateTime(ts, vbLongTime) >> 00:05:08

Rijwan Ansari · Answer

Again you can format output as >> secs = 308 >> ts = TimeSerial(0, 0, secs) >> WScript.Echo FormatDateTime(ts, vbLongTime) >> 00:05:08

Rajanikant Hawaldar · Answer

try below, if you want to skip AM/PM you can try using "right" Date1 = alA_Filling(0) Date2 = alA_Filling(1) secValue = DateDiff( "s" ,Date1,Date2) ts = TimeSerial(0, 0, secValue) Duration = FormatDateTime(ts, vbLongTime)

Jhon ABhu · Answer

if duration above 1 hour showing correctly like 01:44:00 like this if Duration below 1 hour......... if 32 miutes the showing 12:32:00 ouput should be like 00:32:00

Jhon ABhu · Answer

Thanks a lot working perfect but result like 2:49:00 AM how to remove "AM"

Jhon ABhu · Answer

where you comparing the dates and where did you assign can u show me clearly

Jhon ABhu · Answer

unable to understand sorry

Jhon ABhu · Answer

ouput should be HH:MM:SS and stored in variable