Sideway BICK BlogSideway BICK BLOG from Sideway

A Sideway to Sideway Home
Home
Output.to

Link:http://output.to/sideway/default.asp?qno=180300025

Script, Scripting Language, VBScript elements, Server-Side VBScript Function DateAdd, DateDiff Function

VBScript Date/Time Functions

Functions for manipulating date or time dexpression.

DateAdd Function

last updated 9/17/2017

Create a date from a given date by adding the specified number of interval to the given date.

Syntax

DateAdd(interval, number, date)

Argument

intervalRequired setting. Any valid String setting that is used to specify the interval of period to be added to the given date.numberRequired. Any valid numeric value that is used to specify the amount of the interval of period to be added to the given date.dateRequired. Any valid Date expression that is used for evaluation.

Settings

interval argument

SettingDescriptionyyyyYear partqQuarter of a year partmMonth part.yDay of a year part.dDay (of a month) part.wWeekday (Day) of a week part.wwWeek of a year part.hHour part.nMinute part.sSecond part.

Returns

Returns a Variant of Date data subtype containing the date obtained from a given date by adding the specified number of interval to the given date.

Special returns of function:

intervalnumberdatereturn valueAny ValidAny ValidNullNullAny ValidEmpty, 0Empty, 0#12:00:00 AM#yyyy,q,m,y,d,w,ww|num|>0Empty, 0#12/30/1899#+[num]intevalh,n,s|num|>0Empty, 0#12:00:00 AM#+[num]intevalAny ValidEmpty, 0dte>0#12/30/1899#+[dte]daysyyyy,q,m,y,d,w,ww|num|>0dte>0#12/30/1899#+[dte]days+[num]intevalh,n,s|num|>0dte>0#12/30/1899 12:00:00 AM#+[dte]days+[num]intevalAny Valid0#dd/mmm hr:min##dd/mmm/current year hr:min:00#Any Valid|num|>0#dd/mmm hr:min##dd/mmm/current year hr:min:00#+[num]intervalAny Valid0#dd/mmm/yyyy##dd/mmm/yyyy#yyyy,q,m,y,d,w,ww|num|>0#dd/mmm/yyyy##dd/mmm/yyyy#+[num]intervalh,n,s|num|>0#dd/mmm/yyyy##dd/mmm/yyyy 12:00:00 AM#+[num]intervalAny Valid0#hr:min:sec##hr:min:sec (AM/PM)#yyyy,q,m,y,d,w,ww|num|>0#hr:min:sec##12/30/1899 hr:min:sec (AM/PM)#+[num]intervalh,n,s|num|>0#hr:min:sec##hr:min:sec AM#+[num]intervalAnyNullAnyRun-time error

Remarks

  • DateAdd function can be used to add or subtract a specified time interval from a given date.
  • The DateAdd function always return a Variant of Date data subtype.
  • If the calculated date would precede the year 100, an Run-time error occurs.
  • The interval argument setting must be any valid expression of the set {"yyyy","q","m","y","d","w","ww","h","n","s"}.
  • Number argument can be any numeric expression and the value is equal to Round(number).
  • If date argument contains Null, DateAdd function always returns Null.
  • If number contains Empty or 0, DateAdd function always returns the given date according to the general rules.
  • The preset zero-date is equal to #12/30/1899 12:00:00 AM#.
  • If both date and number contains Empty or 0, DateAdd function returns #12:00:00 AM#.
  • If number argument is not equal to zero, the interval argument will affect the form of the return date.
  • In general, interval argument with value equals to one of {"yyyy","q","m","y","d","w","ww"} will only trigger and affect the date part of the given date, while interval argument with value equals to one of {"h","n","s"} will only trigger and affect the time part of the given date.

Requirement

2

Examples

Examples of DateAdd function

ASP VbScript Command:
<script runat="server" language="VBScript">
Dim vars,dte,cmda,var:var=0
cmda=array("dte","DateAdd(""yyyy"",cnt,dte)","DateAdd(""q"",cnt,dte)","DateAdd(""m"",cnt,dte)","DateAdd(""y"",cnt,dte)","DateAdd(""d"",cnt,dte)","DateAdd(""w"",cnt,dte)","DateAdd(""ww"",cnt,dte)","DateAdd(""h"",cnt,dte)","DateAdd(""n"",cnt,dte)","DateAdd(""s"",cnt,dte)")
Dim ucnt,tmp,i:ucnt=UBound(cmda):If var=1 Then:tmp="":Else:tmp="<b>vars</b>":End If:For i=0 to ucnt:tmp=tmp&"<b>"&rmv_ctrl(cmda(i))&", TypeName</b>":Next:Response.Write "Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp<br />"&"<i>"&tmp&"</i>"
Function dsp_x:Dim tmp_a,tmp_b,i:If varx=0  Then:Execute vars:End If:If var=1 Then:tmp_a="":Else:tmp_a=rmv_ctrl(vars):End If:For i=0 to ucnt:tmp_b=cmd_b(cmda(i)):if i/2=fix(i/2) Then:tmp_b="<b>"&tmp_b&"</b>":End If:tmp_a=tmp_a&tmp_b:Next:Response.Write "<i>"&tmp_a&"</i>":End Function
Function rmv_ctrl(blk_str):Select Case blk_str:Case chr(0):blk_str="NUL":Case chr(1):blk_str="SOH":Case chr(2):blk_str="STX":Case chr(3):blk_str="ETX":Case chr(4):blk_str="EOT":Case chr(5):blk_str="ENQ":Case chr(6):blk_str="ACK":Case chr(7):blk_str="BEL":Case chr(8):blk_str="BS":Case chr(9):blk_str="HT":Case chr(10):blk_str="LF":Case chr(11):blk_str="VT":Case chr(12):blk_str="FF":Case chr(13):blk_str="CR":Case chr(14):blk_str="SO":Case chr(15):blk_str="SI":Case chr(16):blk_str="DLE":Case chr(17):blk_str="DC1":Case chr(18):blk_str="DC2":Case chr(19):blk_str="DC3":Case chr(20):blk_str="DC4":Case chr(21):blk_str="NAK":Case chr(22):blk_str="SYN":Case chr(23):blk_str="ETB":Case chr(24):blk_str="CAN":Case chr(25):blk_str="EM":Case chr(26):blk_str="SUB":Case chr(27):blk_str="ESC":Case chr(28):blk_str="FS":Case chr(29):blk_str="GS":Case chr(30):blk_str="RS":Case chr(31):blk_str="US":Case chr(127):blk_str="DEL":End Select:rmv_ctrl=blk_str:If IsNull(blk_str) OR IsEmpty(Blk_str) OR blk_str="" OR IsNumeric(Blk_str) Then:Else:rmv_ctrl=Replace(Replace(Replace(Replace(Replace(blk_str,"&","&amp;"),"  "," &nbsp;"),"""","&quot;"),"<","&lt;"),">","&gt;"): End If :End Function
Function cmd_b(blk_str):cmd_b="["&cmd_x(blk_str)&"], "&cmd_x("TypeName("&blk_str&")"):End Function
Function cmd_x(blk_str):On Error Resume Next:Dim xans, tmp:xans="":tmp="":execute "xans="&blk_str:If Err.Number <> 0  Then:xans=cmd_x("TypeName("&blk_str&")"):Select Case xans:Case 9::Case Else:xans="error":End Select:End If:If IsArray(xans)=False Then:cmd_x=rmv_ctrl(xans): Else:tmp=lst_arry(xans):cmd_x=trim(tmp):End If:End Function
Function lst_arry(blk_str):Dim tmp,i,q:q="""":tmp="":For i=0 to UBound(blk_str):if VarType(blk_str(i))>1 And VarType(blk_str(i))<6 Then:q="'":End If:tmp=tmp&" "&q&rmv_ctrl(blk_str(i))&q:Next:lst_arry=trim(tmp):End Function

vars="cnt=Empty:dte=Null":dsp_x
vars="cnt=0:dte=Null":dsp_x
vars="cnt=1:dte=Null":dsp_x
vars="cnt=Empty:dte=Empty":dsp_x
vars="cnt=0:dte=Empty":dsp_x
vars="cnt=1:dte=Empty":dsp_x
vars="cnt=2:dte=Empty":dsp_x
vars="cnt=Empty:dte=""0""":dsp_x
vars="cnt=0:dte=""0""":dsp_x
vars="cnt=1:dte=""0""":dsp_x
vars="cnt=2:dte=""0""":dsp_x
vars="cnt=Empty:dte=0":dsp_x
vars="cnt=0:dte=0":dsp_x
vars="cnt=1:dte=0":dsp_x
vars="cnt=Empty:dte=1":dsp_x
vars="cnt=0:dte=1":dsp_x
vars="cnt=1:dte=1":dsp_x
vars="cnt=2:dte=1":dsp_x
vars="cnt=Empty:dte=Now":dsp_x
vars="cnt=0:dte=Now":dsp_x
vars="cnt=1:dte=Now":dsp_x
vars="cnt=Empty:dte=#10/13/2017 3:26:07#":dsp_x
vars="cnt=0:dte=""10/13/2017 3:26:07 PM""":dsp_x
vars="cnt=1:dte=#10/13/2017 15:26:07#":dsp_x
vars="cnt=0:dte=#10/13 15:26 #":dsp_x
vars="cnt=1:dte=#10/13 15:26 #":dsp_x
vars="cnt=0:dte=#10/13/2011#":dsp_x
vars="cnt=1:dte=#10/13/2011#":dsp_x
vars="cnt=0:dte=#10/13#":dsp_x
vars="cnt=1:dte=#10/13#":dsp_x
vars="cnt=0:dte=#15:26:07#":dsp_x
vars="cnt=1:dte=#15:26:07#":dsp_x
vars="cnt=0:dte=#15:26#":dsp_x
vars="cnt=1:dte=#15:26#":dsp_x
</script>
HTML Web Page In-line Output:
Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp
varsdte, TypeNameDateAdd("yyyy",cnt,dte), TypeNameDateAdd("q",cnt,dte), TypeNameDateAdd("m",cnt,dte), TypeNameDateAdd("y",cnt,dte), TypeNameDateAdd("d",cnt,dte), TypeNameDateAdd("w",cnt,dte), TypeNameDateAdd("ww",cnt,dte), TypeNameDateAdd("h",cnt,dte), TypeNameDateAdd("n",cnt,dte), TypeNameDateAdd("s",cnt,dte), TypeNamecnt=Empty:dte=Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Nullcnt=0:dte=Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Nullcnt=1:dte=Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Nullcnt=Empty:dte=Empty[], Empty[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Datecnt=0:dte=Empty[], Empty[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Datecnt=1:dte=Empty[], Empty[12/30/1900], Date[3/30/1900], Date[1/30/1900], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[1/6/1900], Date[1:00:00 AM], Date[12:01:00 AM], Date[12:00:01 AM], Datecnt=2:dte=Empty[], Empty[12/30/1901], Date[6/30/1900], Date[2/28/1900], Date[1/1/1900], Date[1/1/1900], Date[1/1/1900], Date[1/13/1900], Date[2:00:00 AM], Date[12:02:00 AM], Date[12:00:02 AM], Datecnt=Empty:dte="0"[0], String[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Datecnt=0:dte="0"[0], String[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Datecnt=1:dte="0"[0], String[12/30/1900], Date[3/30/1900], Date[1/30/1900], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[1/6/1900], Date[1:00:00 AM], Date[12:01:00 AM], Date[12:00:01 AM], Datecnt=2:dte="0"[0], String[12/30/1901], Date[6/30/1900], Date[2/28/1900], Date[1/1/1900], Date[1/1/1900], Date[1/1/1900], Date[1/13/1900], Date[2:00:00 AM], Date[12:02:00 AM], Date[12:00:02 AM], Datecnt=Empty:dte=0[0], Integer[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Datecnt=0:dte=0[0], Integer[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Date[12:00:00 AM], Datecnt=1:dte=0[0], Integer[12/30/1900], Date[3/30/1900], Date[1/30/1900], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[1/6/1900], Date[1:00:00 AM], Date[12:01:00 AM], Date[12:00:01 AM], Datecnt=Empty:dte=1[1], Integer[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Datecnt=0:dte=1[1], Integer[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Date[12/31/1899], Datecnt=1:dte=1[1], Integer[12/31/1900], Date[3/31/1900], Date[1/31/1900], Date[1/1/1900], Date[1/1/1900], Date[1/1/1900], Date[1/7/1900], Date[12/31/1899 1:00:00 AM], Date[12/31/1899 12:01:00 AM], Date[12/31/1899 12:00:01 AM], Datecnt=2:dte=1[1], Integer[12/31/1901], Date[6/30/1900], Date[2/28/1900], Date[1/2/1900], Date[1/2/1900], Date[1/2/1900], Date[1/14/1900], Date[12/31/1899 2:00:00 AM], Date[12/31/1899 12:02:00 AM], Date[12/31/1899 12:00:02 AM], Datecnt=Empty:dte=Now[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Datecnt=0:dte=Now[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Date[3/27/2019 9:26:38 AM], Datecnt=1:dte=Now[3/27/2019 9:26:38 AM], Date[3/27/2020 9:26:38 AM], Date[6/27/2019 9:26:38 AM], Date[4/27/2019 9:26:38 AM], Date[3/28/2019 9:26:38 AM], Date[3/28/2019 9:26:38 AM], Date[3/28/2019 9:26:38 AM], Date[4/3/2019 9:26:38 AM], Date[3/27/2019 10:26:38 AM], Date[3/27/2019 9:27:38 AM], Date[3/27/2019 9:26:39 AM], Datecnt=Empty:dte=#10/13/2017 3:26:07#[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Date[10/13/2017 3:26:07 AM], Datecnt=0:dte="10/13/2017 3:26:07 PM"[10/13/2017 3:26:07 PM], String[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Date[10/13/2017 3:26:07 PM], Datecnt=1:dte=#10/13/2017 15:26:07#[10/13/2017 3:26:07 PM], Date[10/13/2018 3:26:07 PM], Date[1/13/2018 3:26:07 PM], Date[11/13/2017 3:26:07 PM], Date[10/14/2017 3:26:07 PM], Date[10/14/2017 3:26:07 PM], Date[10/14/2017 3:26:07 PM], Date[10/20/2017 3:26:07 PM], Date[10/13/2017 4:26:07 PM], Date[10/13/2017 3:27:07 PM], Date[10/13/2017 3:26:08 PM], Datecnt=0:dte=#10/13 15:26 #[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Date[10/13/2019 3:26:00 PM], Datecnt=1:dte=#10/13 15:26 #[10/13/2019 3:26:00 PM], Date[10/13/2020 3:26:00 PM], Date[1/13/2020 3:26:00 PM], Date[11/13/2019 3:26:00 PM], Date[10/14/2019 3:26:00 PM], Date[10/14/2019 3:26:00 PM], Date[10/14/2019 3:26:00 PM], Date[10/20/2019 3:26:00 PM], Date[10/13/2019 4:26:00 PM], Date[10/13/2019 3:27:00 PM], Date[10/13/2019 3:26:01 PM], Datecnt=0:dte=#10/13/2011#[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Date[10/13/2011], Datecnt=1:dte=#10/13/2011#[10/13/2011], Date[10/13/2012], Date[1/13/2012], Date[11/13/2011], Date[10/14/2011], Date[10/14/2011], Date[10/14/2011], Date[10/20/2011], Date[10/13/2011 1:00:00 AM], Date[10/13/2011 12:01:00 AM], Date[10/13/2011 12:00:01 AM], Datecnt=0:dte=#10/13#[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Date[10/13/2019], Datecnt=1:dte=#10/13#[10/13/2019], Date[10/13/2020], Date[1/13/2020], Date[11/13/2019], Date[10/14/2019], Date[10/14/2019], Date[10/14/2019], Date[10/20/2019], Date[10/13/2019 1:00:00 AM], Date[10/13/2019 12:01:00 AM], Date[10/13/2019 12:00:01 AM], Datecnt=0:dte=#15:26:07#[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Date[3:26:07 PM], Datecnt=1:dte=#15:26:07#[3:26:07 PM], Date[12/30/1900 3:26:07 PM], Date[3/30/1900 3:26:07 PM], Date[1/30/1900 3:26:07 PM], Date[12/31/1899 3:26:07 PM], Date[12/31/1899 3:26:07 PM], Date[12/31/1899 3:26:07 PM], Date[1/6/1900 3:26:07 PM], Date[4:26:07 PM], Date[3:27:07 PM], Date[3:26:08 PM], Datecnt=0:dte=#15:26#[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Date[3:26:00 PM], Datecnt=1:dte=#15:26#[3:26:00 PM], Date[12/30/1900 3:26:00 PM], Date[3/30/1900 3:26:00 PM], Date[1/30/1900 3:26:00 PM], Date[12/31/1899 3:26:00 PM], Date[12/31/1899 3:26:00 PM], Date[12/31/1899 3:26:00 PM], Date[1/6/1900 3:26:00 PM], Date[4:26:00 PM], Date[3:27:00 PM], Date[3:26:01 PM], Date

DateDiff Function

last updated 9/18/2017

Create a number from two given dates by counting the specified interval from date1 to date2 according to firstdayofweek and firstweekofyear setting.

Syntax

DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]])

Argument

intervalRequired setting. Any valid String setting that is used to specify the interval of period for counting one complete unit of the number to be returned.date1Required. Any valid Date expression that is the beginning date being subtracted.date2Required. Any valid Date expression that is the end date from which date1 is being subtracted.firstdayofweekOptional seting. Any valid Constant that is used to specify the first day of a week. If firstdayofweek argument is omitted, vbSunday or 1 is used and Sunday is assumed to be the first day of a week.firstweekofyearOptional setting. Any valid Constant that is used to specify the first week of a year. If firstweekofyear argument is omitted, vbFistJan1 or 1 is used and the first week is assumed to be the week in which January 1 occurs.

Settings

interval argument

SettingDescriptionyyyyYear partqQuarter of a year partmMonth part.yDay of a year part.dDay (of a month) part.wWeekday (Day) of a week part.wwWeek of a year part.hHour part.nMinute part.sSecond part.

firstdayofweek argument

vbConstantValueDescriptionvbUseSystemDayOfWeek0Use National Language Support (NLS) API setting.vbSunday1(default)Sunday .vbMonday2Monday.vbTuesday3Tuesday.vbWednesday4Wednesday.vbThursday5Thursday.vbFriday6Friday.vbSaturday7Saturday.

firstweekofyear argument

vbConstantValueDescriptionvbUseSystem0Use National Language Support (NLS) API setting.vbFirstJan11(default)Start with the week in which January 1 occurs.vbFirstFourDays2Start with the week that has at least four days in the new year.vbFirstFullWeek3Start with the first full week of the new year.

Returns

Returns a Variant of Long data subtype containing the number obtained from two given dates by counting the specified interval from date1 to date2 according to firstdayofweek and firstweekofyear setting.

Special returns of function:

intervaldate1date2firstdayofweekfirstweekofyearreturn valueAny ValidNullAny ValidAny ValidAny ValidNullAny ValidAny ValidNullAny ValidAny ValidNullAny ValidEmpty, 0 Empty, 0Any ValidAny Valid0

Remarks

  • DateDiff function is used to determine the number of count of the specified interval of period achieved after the given date1.
  • The interval argument setting must be any valid expression of the set {"yyyy","q","m","y","d","w","ww","h","n","s"}.
  • The date1 argument is the beginning value being subtracted, while the date2 argument is the end value from which date1 is being subtracted.
  • If the specified date1 is later than the specified date2, the Datediff function returns a negative number to indicate that the given date1 and date2 are in reversed order.
  • If interval argument is "yyyy", DateDiff function returns the number of a year interval of period between the year parts of date1 and date2. In other words, the year parts of date1 and date2 cover a period of 2 years or the year interval of period achieved after the given date1 is 1, when the number returned is equal to 1.
  • Similarly, if interval argument is "q", DateDiff function returns the number of a quarter interval of period between the quarter parts and above of date1 and date2. The four quarters that make up the year are: January, February and March (Q1); April, May and June (Q2); July, August and September (Q3); and October, November and December (Q4).
  • Similarly, if interval argument is "m", DateDiff function returns the number of a month interval of period between the month parts and above of date1 and date2.
  • However, either the "y", day of year or "d" day of month interval argument is used to count the number of a days interval between date1 and date2 of which the time part is ignored.
  • Similar to month interval, if interval argument is "w", DateDiff function returns the number of a week of full 7-day interval of period according to the weekday of date1 between the weekday parts and above of date1 and date2.
  • However, if interval argument is "ww", DateDiff function returns the number of a week of full 7-day interval of period according to the first day of week setting between the weekday parts and above of date1 and date2.
  • Although, the firstdayofweek and firstweekofyear setting affect the evaluation of the interval settings "w" and "ww", only the interval argument "w" is affected. Since both "w" and "ww" setting are a week of full 7-day interval of period, the firstweekofyear does not affect the returns of both interval settings. The interval stting "w" depends only on the weekday of date1, the return is therefore not affected by firstdayofweek also. However the interval stting "ww" depends on the firstdayofweek, the return is therefore affected by firstdayofweek.
  • Similarly, if interval argument is "h", DateDiff function returns the number of a hour interval of period between the hour parts and above of date1 and date2.
  • Similarly, if interval argument is "n", DateDiff function returns the number of a minute interval of period between the minute parts and above of date1 and date2.
  • Similarly, if interval argument is "s", DateDiff function returns the number of a second interval of period between the second parts and above of date1 and date2.
  • The preset zero-date is equal to #12/30/1899 12:00:00 AM#.
  • For any given date, if day and month is given while year is omitted, the current year of locate system time is used as the year part. For any givn time, if minute and hour is given while second is omitted, 0 is used as the second part.

Requirement

2

Examples

Examples of functions

ASP VbScript Command:
<script runat="server" language="VBScript">
Dim ivl_arry:ivl_arry=array("yyyy","q","m","y","d","w","ww","h","n","s")
Dim vars,ivl,dt1,dt2,fdw,fwy,cmda,var:var=0
cmda=array("dt1","dt2","DateDiff(ivl,dt1,dt2)","DateDiff(ivl,dt1,dt2,fdw)","DateDiff(ivl,dt1,dt2,fdw,fwy)")
Dim ucnt,tmp,i:ucnt=UBound(cmda):If var=1 Then:tmp="":Else:tmp="<b>vars</b>":End If:For i=0 to ucnt:tmp=tmp&"<b>"&rmv_ctrl(cmda(i))&", TypeName</b>":Next:Response.Write "Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp<br />"&"<i>"&tmp&"</i>"
Function dsp_x:Dim tmp_a,tmp_b,i:If varx=0  Then:Execute vars:End If:If var=1 Then:tmp_a="":Else:tmp_a=rmv_ctrl(vars):End If:For i=0 to ucnt:tmp_b=cmd_b(cmda(i)):if i/2=fix(i/2) Then:tmp_b="<b>"&tmp_b&"</b>":End If:tmp_a=tmp_a&tmp_b:Next:Response.Write "<i>"&tmp_a&"</i>":End Function
Function rmv_ctrl(blk_str):Select Case blk_str:Case chr(0):blk_str="NUL":Case chr(1):blk_str="SOH":Case chr(2):blk_str="STX":Case chr(3):blk_str="ETX":Case chr(4):blk_str="EOT":Case chr(5):blk_str="ENQ":Case chr(6):blk_str="ACK":Case chr(7):blk_str="BEL":Case chr(8):blk_str="BS":Case chr(9):blk_str="HT":Case chr(10):blk_str="LF":Case chr(11):blk_str="VT":Case chr(12):blk_str="FF":Case chr(13):blk_str="CR":Case chr(14):blk_str="SO":Case chr(15):blk_str="SI":Case chr(16):blk_str="DLE":Case chr(17):blk_str="DC1":Case chr(18):blk_str="DC2":Case chr(19):blk_str="DC3":Case chr(20):blk_str="DC4":Case chr(21):blk_str="NAK":Case chr(22):blk_str="SYN":Case chr(23):blk_str="ETB":Case chr(24):blk_str="CAN":Case chr(25):blk_str="EM":Case chr(26):blk_str="SUB":Case chr(27):blk_str="ESC":Case chr(28):blk_str="FS":Case chr(29):blk_str="GS":Case chr(30):blk_str="RS":Case chr(31):blk_str="US":Case chr(127):blk_str="DEL":End Select:rmv_ctrl=blk_str:If IsNull(blk_str) OR IsEmpty(Blk_str) OR blk_str="" OR IsNumeric(Blk_str) Then:Else:rmv_ctrl=Replace(Replace(Replace(Replace(Replace(blk_str,"&","&amp;"),"  "," &nbsp;"),"""","&quot;"),"<","&lt;"),">","&gt;"): End If :End Function
Function cmd_b(blk_str):cmd_b="["&cmd_x(blk_str)&"], "&cmd_x("TypeName("&blk_str&")"):End Function
Function cmd_x(blk_str):On Error Resume Next:Dim xans, tmp:xans="":tmp="":execute "xans="&blk_str:If Err.Number <> 0  Then:xans=cmd_x("TypeName("&blk_str&")"):Select Case xans:Case 9::Case Else:xans="error":End Select:End If:If IsArray(xans)=False Then:cmd_x=rmv_ctrl(xans): Else:tmp=lst_arry(xans):cmd_x=trim(tmp):End If:End Function
Function lst_arry(blk_str):Dim tmp,i,q:q="""":tmp="":For i=0 to UBound(blk_str):if VarType(blk_str(i))>1 And VarType(blk_str(i))<6 Then:q="'":End If:tmp=tmp&" "&q&rmv_ctrl(blk_str(i))&q:Next:lst_arry=trim(tmp):End Function

For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Null:dt2=Null:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Null:dt2=Empty:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Null:dt2=0:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Null:dt2=1:fdw=1:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Empty:dt2=Null:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Empty:dt2=Empty:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Empty:dt2=0:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=Empty:dt2=1:fdw=1:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=0:dt2=Null:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=0:dt2=Empty:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=0:dt2=0:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=0:dt2=1:fdw=1:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=1:dt2=Null:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=1:dt2=Empty:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=1:dt2=0:fdw=1:fwy=1":dsp_x:Next
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=1:dt2=1:fdw=1:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=0:dt2=8:fdw=2:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
For i=0 to UBound(ivl_arry):vars="ivl="""&ivl_arry(i)&""":dt1=0:dt2=#1/18#:fdw=7:fwy=1":dsp_x:Next
Response.Write "<i>&nbsp;</i>"
</script>
HTML Web Page In-line Output:
Results on Microsoft Windows 8.1 Pro x64, Microsoft-IIS/8.5, VBScript Version 5.8 of page /internet/users/sideblog/default.asp
varsdt1, TypeNamedt2, TypeNameDateDiff(ivl,dt1,dt2), TypeNameDateDiff(ivl,dt1,dt2,fdw), TypeNameDateDiff(ivl,dt1,dt2,fdw,fwy), TypeNameivl="yyyy":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="q":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="m":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="y":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="d":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="w":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="ww":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="h":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="n":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="s":dt1=Null:dt2=Null:fdw=1:fwy=1[], Null[], Null[], Null[], Null[], Nullivl="yyyy":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="q":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="m":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="y":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="d":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="w":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="ww":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="h":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="n":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="s":dt1=Null:dt2=Empty:fdw=1:fwy=1[], Null[], Empty[], Null[], Null[], Nullivl="yyyy":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="q":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="m":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="y":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="d":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="w":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="ww":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="h":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="n":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="s":dt1=Null:dt2=0:fdw=1:fwy=1[], Null[0], Integer[], Null[], Null[], Nullivl="yyyy":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="q":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="m":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="y":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="d":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="w":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="ww":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="h":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="n":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Nullivl="s":dt1=Null:dt2=1:fdw=1:fwy=1[], Null[1], Integer[], Null[], Null[], Null ivl="yyyy":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="q":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="m":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="y":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="d":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="w":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="ww":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="h":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="n":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="s":dt1=Empty:dt2=Null:fdw=1:fwy=1[], Empty[], Null[], Null[], Null[], Nullivl="yyyy":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="q":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="m":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="y":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="d":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="w":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="ww":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="h":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="n":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="s":dt1=Empty:dt2=Empty:fdw=1:fwy=1[], Empty[], Empty[0], Long[0], Long[0], Longivl="yyyy":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="q":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="m":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="y":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="d":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="w":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="ww":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="h":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="n":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="s":dt1=Empty:dt2=0:fdw=1:fwy=1[], Empty[0], Integer[0], Long[0], Long[0], Longivl="yyyy":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[0], Long[0], Long[0], Longivl="q":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[0], Long[0], Long[0], Longivl="m":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[0], Long[0], Long[0], Longivl="y":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[1], Long[1], Long[1], Longivl="d":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[1], Long[1], Long[1], Longivl="w":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[0], Long[0], Long[0], Longivl="ww":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[1], Long[1], Long[1], Longivl="h":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[24], Long[24], Long[24], Longivl="n":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[1440], Long[1440], Long[1440], Longivl="s":dt1=Empty:dt2=1:fdw=1:fwy=1[], Empty[1], Integer[86400], Long[86400], Long[86400], Long ivl="yyyy":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="q":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="m":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="y":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="d":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="w":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="ww":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="h":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="n":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="s":dt1=0:dt2=Null:fdw=1:fwy=1[0], Integer[], Null[], Null[], Null[], Nullivl="yyyy":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="q":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="m":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="y":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="d":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="w":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="ww":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="h":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="n":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="s":dt1=0:dt2=Empty:fdw=1:fwy=1[0], Integer[], Empty[0], Long[0], Long[0], Longivl="yyyy":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="q":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="m":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="y":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="d":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="w":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="ww":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="h":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="n":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="s":dt1=0:dt2=0:fdw=1:fwy=1[0], Integer[0], Integer[0], Long[0], Long[0], Longivl="yyyy":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[0], Long[0], Long[0], Longivl="q":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[0], Long[0], Long[0], Longivl="m":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[0], Long[0], Long[0], Longivl="y":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[1], Long[1], Long[1], Longivl="d":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[1], Long[1], Long[1], Longivl="w":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[0], Long[0], Long[0], Longivl="ww":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[1], Long[1], Long[1], Longivl="h":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[24], Long[24], Long[24], Longivl="n":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[1440], Long[1440], Long[1440], Longivl="s":dt1=0:dt2=1:fdw=1:fwy=1[0], Integer[1], Integer[86400], Long[86400], Long[86400], Long ivl="yyyy":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="q":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="m":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="y":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="d":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="w":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="ww":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="h":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="n":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="s":dt1=1:dt2=Null:fdw=1:fwy=1[1], Integer[], Null[], Null[], Null[], Nullivl="yyyy":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[0], Long[0], Long[0], Longivl="q":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[0], Long[0], Long[0], Longivl="m":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[0], Long[0], Long[0], Longivl="y":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[-1], Long[-1], Long[-1], Longivl="d":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[-1], Long[-1], Long[-1], Longivl="w":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[0], Long[0], Long[0], Longivl="ww":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[-1], Long[-1], Long[-1], Longivl="h":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[-24], Long[-24], Long[-24], Longivl="n":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[-1440], Long[-1440], Long[-1440], Longivl="s":dt1=1:dt2=Empty:fdw=1:fwy=1[1], Integer[], Empty[-86400], Long[-86400], Long[-86400], Longivl="yyyy":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[0], Long[0], Long[0], Longivl="q":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[0], Long[0], Long[0], Longivl="m":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[0], Long[0], Long[0], Longivl="y":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[-1], Long[-1], Long[-1], Longivl="d":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[-1], Long[-1], Long[-1], Longivl="w":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[0], Long[0], Long[0], Longivl="ww":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[-1], Long[-1], Long[-1], Longivl="h":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[-24], Long[-24], Long[-24], Longivl="n":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[-1440], Long[-1440], Long[-1440], Longivl="s":dt1=1:dt2=0:fdw=1:fwy=1[1], Integer[0], Integer[-86400], Long[-86400], Long[-86400], Longivl="yyyy":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="q":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="m":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="y":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="d":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="w":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="ww":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="h":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="n":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Longivl="s":dt1=1:dt2=1:fdw=1:fwy=1[1], Integer[1], Integer[0], Long[0], Long[0], Long ivl="yyyy":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[1], Long[1], Long[1], Longivl="q":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[1], Long[1], Long[1], Longivl="m":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[1], Long[1], Long[1], Longivl="y":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[8], Long[8], Long[8], Longivl="d":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[8], Long[8], Long[8], Longivl="w":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[1], Long[1], Long[1], Longivl="ww":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[2], Long[1], Long[1], Longivl="h":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[192], Long[192], Long[192], Longivl="n":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[11520], Long[11520], Long[11520], Longivl="s":dt1=0:dt2=8:fdw=2:fwy=1[0], Integer[8], Integer[691200], Long[691200], Long[691200], Long ivl="yyyy":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[1], Long[1], Long[1], Longivl="q":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[3], Long[3], Long[3], Longivl="m":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[7], Long[7], Long[7], Longivl="y":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[213], Long[213], Long[213], Longivl="d":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[213], Long[213], Long[213], Longivl="w":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[30], Long[30], Long[30], Longivl="ww":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[30], Long[31], Long[31], Longivl="h":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[5112], Long[5112], Long[5112], Longivl="n":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[306720], Long[306720], Long[306720], Longivl="s":dt1=#12/30/2015#:dt2=#7/30/2016#:fdw=5:fwy=3[12/30/2015], Date[7/30/2016], Date[18403200], Long[18403200], Long[18403200], Long ivl="yyyy":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[3], Long[3], Long[3], Longivl="q":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[9], Long[9], Long[9], Longivl="m":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[25], Long[25], Long[25], Longivl="y":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[739], Long[739], Long[739], Longivl="d":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[739], Long[739], Long[739], Longivl="w":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[105], Long[105], Long[105], Longivl="ww":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[106], Long[105], Long[105], Longivl="h":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[17736], Long[17736], Long[17736], Longivl="n":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[1064160], Long[1064160], Long[1064160], Longivl="s":dt1=#12/30/2016#:dt2=#01/8#:fdw=5:fwy=1[12/30/2016], Date[1/8/2019], Date[63849600], Long[63849600], Long[63849600], Long ivl="yyyy":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[3], Long[3], Long[3], Longivl="q":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[9], Long[9], Long[9], Longivl="m":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[25], Long[25], Long[25], Longivl="y":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[739], Long[739], Long[739], Longivl="d":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[739], Long[739], Long[739], Longivl="w":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[105], Long[105], Long[105], Longivl="ww":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[106], Long[105], Long[105], Longivl="h":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[17736], Long[17736], Long[17736], Longivl="n":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[1064160], Long[1064160], Long[1064160], Longivl="s":dt1=#12/30/2016#:dt2=#01/8#:fdw=6:fwy=1[12/30/2016], Date[1/8/2019], Date[63849600], Long[63849600], Long[63849600], Long ivl="yyyy":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[3], Long[3], Long[3], Longivl="q":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[9], Long[9], Long[9], Longivl="m":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[25], Long[25], Long[25], Longivl="y":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[739], Long[739], Long[739], Longivl="d":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[739], Long[739], Long[739], Longivl="w":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[105], Long[105], Long[105], Longivl="ww":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[106], Long[106], Long[106], Longivl="h":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[17736], Long[17736], Long[17736], Longivl="n":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[1064160], Long[1064160], Long[1064160], Longivl="s":dt1=#12/30/2016#:dt2=#01/8#:fdw=7:fwy=1[12/30/2016], Date[1/8/2019], Date[63849600], Long[63849600], Long[63849600], Long ivl="yyyy":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[3], Long[3], Long[3], Longivl="q":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[9], Long[9], Long[9], Longivl="m":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[25], Long[25], Long[25], Longivl="y":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[744], Long[744], Long[744], Longivl="d":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[744], Long[744], Long[744], Longivl="w":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[106], Long[106], Long[106], Longivl="ww":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[107], Long[106], Long[106], Longivl="h":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[17856], Long[17856], Long[17856], Longivl="n":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[1071360], Long[1071360], Long[1071360], Longivl="s":dt1=#12/30/2016#:dt2=#01/13#:fdw=5:fwy=1[12/30/2016], Date[1/13/2019], Date[64281600], Long[64281600], Long[64281600], Long ivl="yyyy":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[3], Long[3], Long[3], Longivl="q":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[9], Long[9], Long[9], Longivl="m":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[25], Long[25], Long[25], Longivl="y":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[744], Long[744], Long[744], Longivl="d":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[744], Long[744], Long[744], Longivl="w":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[106], Long[106], Long[106], Longivl="ww":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[107], Long[106], Long[106], Longivl="h":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[17856], Long[17856], Long[17856], Longivl="n":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[1071360], Long[1071360], Long[1071360], Longivl="s":dt1=#12/30/2016#:dt2=#01/13#:fdw=6:fwy=1[12/30/2016], Date[1/13/2019], Date[64281600], Long[64281600], Long[64281600], Long ivl="yyyy":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[3], Long[3], Long[3], Longivl="q":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[9], Long[9], Long[9], Longivl="m":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[25], Long[25], Long[25], Longivl="y":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[744], Long[744], Long[744], Longivl="d":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[744], Long[744], Long[744], Longivl="w":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[106], Long[106], Long[106], Longivl="ww":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[107], Long[107], Long[107], Longivl="h":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[17856], Long[17856], Long[17856], Longivl="n":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[1071360], Long[1071360], Long[1071360], Longivl="s":dt1=#12/30/2016#:dt2=#01/13#:fdw=7:fwy=1[12/30/2016], Date[1/13/2019], Date[64281600], Long[64281600], Long[64281600], Long ivl="yyyy":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="q":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="m":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="y":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="d":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="w":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="ww":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="h":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[0], Long[0], Long[0], Longivl="n":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[20], Long[20], Long[20], Longivl="s":dt1=#12:20:20#:dt2=#12:40:40#:fdw=7:fwy=1[12:20:20 PM], Date[12:40:40 PM], Date[1220], Long[1220], Long[1220], Long ivl="yyyy":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[0], Long[0], Long[0], Longivl="q":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[0], Long[0], Long[0], Longivl="m":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[0], Long[0], Long[0], Longivl="y":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[0], Long[0], Long[0], Longivl="d":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[0], Long[0], Long[0], Longivl="w":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[0], Long[0], Long[0], Longivl="ww":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[0], Long[0], Long[0], Longivl="h":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[5], Long[5], Long[5], Longivl="n":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[325], Long[325], Long[325], Longivl="s":dt1=#12:20:20#:dt2=#17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[5:45:45 PM], Date[19525], Long[19525], Long[19525], Long ivl="yyyy":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="q":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="m":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="y":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="d":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="w":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="ww":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="h":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[-5], Long[-5], Long[-5], Longivl="n":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[-275], Long[-275], Long[-275], Longivl="s":dt1=#12:20:20#:dt2=#7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[7:45:45 AM], Date[-16475], Long[-16475], Long[-16475], Long ivl="yyyy":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[120], Long[120], Long[120], Longivl="q":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[477], Long[477], Long[477], Longivl="m":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[1429], Long[1429], Long[1429], Longivl="y":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[43483], Long[43483], Long[43483], Longivl="d":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[43483], Long[43483], Long[43483], Longivl="w":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[6211], Long[6211], Long[6211], Longivl="ww":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[6212], Long[6211], Long[6211], Longivl="h":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[1043597], Long[1043597], Long[1043597], Longivl="n":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[62615845], Long[62615845], Long[62615845], Longivl="s":dt1=#12:20:20#:dt2=#1/18 17:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 5:45:45 PM], Date[3756950725], Double[3756950725], Double[3756950725], Double ivl="yyyy":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[120], Long[120], Long[120], Longivl="q":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[477], Long[477], Long[477], Longivl="m":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[1429], Long[1429], Long[1429], Longivl="y":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[43483], Long[43483], Long[43483], Longivl="d":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[43483], Long[43483], Long[43483], Longivl="w":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[6211], Long[6211], Long[6211], Longivl="ww":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[6212], Long[6211], Long[6211], Longivl="h":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[1043587], Long[1043587], Long[1043587], Longivl="n":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[62615245], Long[62615245], Long[62615245], Longivl="s":dt1=#12:20:20#:dt2=#1/18 7:45:45#:fdw=7:fwy=1[12:20:20 PM], Date[1/18/2019 7:45:45 AM], Date[3756914725], Double[3756914725], Double[3756914725], Double ivl="yyyy":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="q":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="m":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="y":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="d":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="w":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="ww":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[0], Long[0], Long[0], Longivl="h":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[7], Long[7], Long[7], Longivl="n":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[465], Long[465], Long[465], Longivl="s":dt1=0:dt2=#7:45:45#:fdw=7:fwy=1[0], Integer[7:45:45 AM], Date[27945], Long[27945], Long[27945], Long ivl="yyyy":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[120], Long[120], Long[120], Longivl="q":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[477], Long[477], Long[477], Longivl="m":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[1429], Long[1429], Long[1429], Longivl="y":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[43483], Long[43483], Long[43483], Longivl="d":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[43483], Long[43483], Long[43483], Longivl="w":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[6211], Long[6211], Long[6211], Longivl="ww":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[6212], Long[6211], Long[6211], Longivl="h":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[1043592], Long[1043592], Long[1043592], Longivl="n":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[62615520], Long[62615520], Long[62615520], Longivl="s":dt1=0:dt2=#1/18#:fdw=7:fwy=1[0], Integer[1/18/2019], Date[3756931200], Double[3756931200], Double[3756931200], Double 
Previous Month  MAR  2018  Next Month
SMTWTFS
123
45678910
11121314151617
18192021222324
25262728293031

Previous Month  JUL  2015  Next Month
SMTWTFS
1234
567891011
12131415161718
19202122232425
262728293031

Sideway BICK Blog

25/03

Copyright © 2000-2020 Sideway . All rights reserved Disclaimerslast modified on 26 January 2013