{"id":236,"date":"2007-12-14T14:00:00","date_gmt":"2007-12-14T22:00:00","guid":{"rendered":"http:\/\/testblog.sapien.com\/index.php\/2007\/12\/14\/when-will-that-happen\/"},"modified":"2007-12-14T14:00:00","modified_gmt":"2007-12-14T22:00:00","slug":"when-will-that-happen","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2007\/12\/14\/when-will-that-happen\/","title":{"rendered":"When Will That Happen?"},"content":{"rendered":"

The other day I showed you how I wrapped the DateDiff<\/strong> function into my own function so that I wouldn’t have to remember that “n” is for minutes, among other things. Well the DateAdd<\/strong> function uses the same constants so it only makes sense to use a wrapper function here as well.<\/p>\n

Function GetDateAdd(dtStart,iInterval,sInterval)
’ Valid interval values are:
’ Months,Days,Minutes,Hours,Seconds and they
’ are not case sensitive <\/font> <\/p>\n

    Select Case LCase(sInterval)
        Case “months”
            result = DateAdd(“M”,iInterval,dtStart) <\/font> <\/p>\n

        Case “days”
            result = DateAdd(“d”,iInterval,dtStart) <\/font> <\/p>\n

        Case “minutes”
            result = DateAdd(“n”,iInterval,dtStart) <\/font> <\/p>\n

        Case “hours”           
            result = DateAdd(“h”,iInterval,dtStart) <\/font> <\/p>\n

        Case “seconds”
             result = DateAdd(“s”,iInterval,dtStart)
        Case Else result=”Unknown interval” <\/font> <\/p>\n

    End Select
    GetDateAdd=result <\/font> <\/p>\n

End Function<\/font> <\/p>\n

The form should look very similar to you if you read my last post. This function will return a calculated date time in the specified interval:<\/p>\n

dtNow=Now
i=7 <\/font> <\/p>\n

WScript.Echo “The date\/time from ” & dtNow & ” in:”
WScript.Echo i & ” Months:  ” & GetDateAdd(dtNow,i,”months”)
WScript.Echo i & ” Days:    ” & GetDateAdd(dtNow,i,”days”)
WScript.Echo i & ” Hours:   ” & GetDateAdd(dtNow,i,”hours”)
WScript.Echo i & ” Minutes: ” & GetDateAdd(dtNow,i,”minutes”)
WScript.Echo i & ” Seconds: ” & GetDateAdd(dtNow,i,”seconds”)<\/font> <\/p>\n

You can also use a negative number to calculate a past date\/time value.<\/p>\n

Again, I’ve attached a text file with the code so you don’t have to copy and paste. <\/p>\n

Technorati Tags: VBScript<\/a>, Scripting<\/a>, Functions<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

The other day I showed you how I wrapped the DateDiff function into my own function so that I wouldn’t have to remember that “n” is for minutes, among other things. Well the DateAdd function uses the same constants so it only makes sense to use a wrapper function here as well.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-236","post","type-post","status-publish","format-standard","hentry","category-vbscript"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=236"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/236\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}