Sideway BICK BlogSideway BICK BLOG from Sideway

A Sideway to Sideway Home
Home
Output.to

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

Script, Scripting Language, VBScript elements, Server-Side VBScript Function DatePart Function

VBScript Date/Time Functions

Functions for manipulating date or time dexpression.

DatePart Function

last updated 9/18/2017

Create a Integer from a given valid Date expression according the the specified interval argument, and firstdayofweek and firstweekofyear settings.

Syntax

DatePart(interval, date[, firstdayofweek[, firstweekofyear]])

Argument

intervalRequired setting. Any valid String setting that is the interval of time to be returned from the given date.dateRequired. Any valid Date expression that is used for evaluation.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 Integer data subtype containing the specified time part obtained from a given valid Date expression according the the specified interval argument, and firstdayofweek and firstweekofyear settings.

Special returns of function:

datereturn valueNullNullEmptyUse Preset zero-Date""Run-time Error

Remarks

  • DatePart function is used to create and return a specified time part of a given date expression according to the specified interval argument.
  • The firstdayofweek argument affects both the weekday number and week number of a date that related to the "w" and "ww" interval arguments.
  • The weekday number of a date depends of the weekday name of the date and the firstdayofweek argument.
  • By default, the firstdayofweek is Sunday, that is weekday number is 1 for Sunday, 2 for Monday, and so on.
  • The firstweekofyear argument together with the firstdayofweek argument affects the weeknumber of a date that related to the "ww" interval argument.
  • The date before the first week of year will be counted as week52/53 of previous year
  • For the "h" interval symbol, the returned hour is always based on a 24-hour clock without the A.M. or P.M. wording.
  • If date contains Null, DatePart function always returns Null.
  • If date contains Empty, DatePart function uses the preset zero-date as date argument.
  • If date is numeric, date is assumed to be equal to the date days from zero-date.
  • If date is not a valid date expression, DatePart function returns Run-time error.
  • If the year of date is omitted while day and month is present, the current year is assumed.
  • If day, month, and year are omitted, the day, month, and year of zero-date are assumed.
  • If second is omitted while minute and hour are present, second is assumed to be zero.
  • If both hour and minute are omitted, the second, minute, and hour of zero-date are assumed.

Requirement

2

Examples

Examples of DatePart function

ASP VbScript Command:
<script runat="server" language="VBScript">
Function cmda1:cmda1="DatePart(ivl,dte,fdw,fwy)":cmda1=Left(cmda1,Len(cmda1)-4*(4-x)-1)&")":End Function
Function cmdb(i):cmdb=Replace(cmda1,"ivl",""""&i&""""):End Function
Dim vars,ivl,dte,fdw,fwy,cmda,var:var=0
cmda=array("dte","Eval(""cmda1"")","Eval(cmdb (""yyyy""))","Eval(cmdb (""q""))","Eval(cmdb (""m""))","Eval(cmdb (""y""))","Eval(cmdb (""d""))","Eval(cmdb (""w""))","Eval(cmdb (""ww""))","Eval(cmdb (""h""))","Eval(cmdb (""n""))","Eval(cmdb (""s""))")
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="dte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=1":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=1":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=1":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=1":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=1":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=2":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=2":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=2":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=2":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2018 12:08:51 PM#:fdw=7:fwy=2":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01 12:08:51 PM#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#01/01/2016#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#10/12#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=""10/12"":fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=""100000"":fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=10:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=""10 Dec"":fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#9:08:51 PM#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#9:08:51#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#21:08:51#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=""21:08:51"":fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#21:08#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=#21:0#:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=Null:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=Empty:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4:dsp_x
vars="dte=0:fdw=7:fwy=3":x=2:dsp_x:x=3:dsp_x:x=4: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, TypeNameEval("cmda1"), TypeNameEval(cmdb ("yyyy")), TypeNameEval(cmdb ("q")), TypeNameEval(cmdb ("m")), TypeNameEval(cmdb ("y")), TypeNameEval(cmdb ("d")), TypeNameEval(cmdb ("w")), TypeNameEval(cmdb ("ww")), TypeNameEval(cmdb ("h")), TypeNameEval(cmdb ("n")), TypeNameEval(cmdb ("s")), TypeNamedte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=1[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=1[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=1[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=1[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[2], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=1[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[2], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=1[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[2], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=3[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[2], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=3[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[2], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=1:fwy=3[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[2], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=1[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=1[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=1[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=1[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=1[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[2], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=1[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[2], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=1[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=1[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=1[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=2[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=2[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=2[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=2[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=2[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=2[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[52], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=2[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=2[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[2], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=2[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[2], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=2[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=2[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=2[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[52], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=3[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=3[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=1:fwy=3[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=7:fwy=2[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[2], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=7:fwy=2[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[3], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2018 12:08:51 PM#:fdw=7:fwy=2[1/1/2018 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2018], Integer[1], Integer[1], Integer[1], Integer[1], Integer[3], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=3[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=3[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=1:fwy=3[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[52], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=3[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[1], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=3[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[2], Integer[53], Integer[12], Integer[8], Integer[51], Integerdte=#12/31/2017 12:08:51 PM#:fdw=7:fwy=3[12/31/2017 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2017], Integer[4], Integer[12], Integer[365], Integer[31], Integer[2], Integer[52], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=3[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=3[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016 12:08:51 PM#:fdw=7:fwy=3[1/1/2016 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[52], Integer[12], Integer[8], Integer[51], Integerdte=#01/01 12:08:51 PM#:fdw=7:fwy=3[1/1/2019 12:08:51 PM], Date[DatePart(ivl,dte)], String[2019], Integer[1], Integer[1], Integer[1], Integer[1], Integer[3], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01 12:08:51 PM#:fdw=7:fwy=3[1/1/2019 12:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[2019], Integer[1], Integer[1], Integer[1], Integer[1], Integer[4], Integer[1], Integer[12], Integer[8], Integer[51], Integerdte=#01/01 12:08:51 PM#:fdw=7:fwy=3[1/1/2019 12:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[2019], Integer[1], Integer[1], Integer[1], Integer[1], Integer[4], Integer[52], Integer[12], Integer[8], Integer[51], Integerdte=#01/01/2016#:fdw=7:fwy=3[1/1/2016], Date[DatePart(ivl,dte)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[6], Integer[1], Integer[0], Integer[0], Integer[0], Integerdte=#01/01/2016#:fdw=7:fwy=3[1/1/2016], Date[DatePart(ivl,dte,fdw)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[1], Integer[0], Integer[0], Integer[0], Integerdte=#01/01/2016#:fdw=7:fwy=3[1/1/2016], Date[DatePart(ivl,dte,fdw,fwy)], String[2016], Integer[1], Integer[1], Integer[1], Integer[1], Integer[7], Integer[52], Integer[0], Integer[0], Integer[0], Integerdte=#10/12#:fdw=7:fwy=3[10/12/2019], Date[DatePart(ivl,dte)], String[2019], Integer[4], Integer[10], Integer[285], Integer[12], Integer[7], Integer[41], Integer[0], Integer[0], Integer[0], Integerdte=#10/12#:fdw=7:fwy=3[10/12/2019], Date[DatePart(ivl,dte,fdw)], String[2019], Integer[4], Integer[10], Integer[285], Integer[12], Integer[1], Integer[42], Integer[0], Integer[0], Integer[0], Integerdte=#10/12#:fdw=7:fwy=3[10/12/2019], Date[DatePart(ivl,dte,fdw,fwy)], String[2019], Integer[4], Integer[10], Integer[285], Integer[12], Integer[1], Integer[41], Integer[0], Integer[0], Integer[0], Integerdte="10/12":fdw=7:fwy=3[10/12], String[DatePart(ivl,dte)], String[2019], Integer[4], Integer[10], Integer[285], Integer[12], Integer[7], Integer[41], Integer[0], Integer[0], Integer[0], Integerdte="10/12":fdw=7:fwy=3[10/12], String[DatePart(ivl,dte,fdw)], String[2019], Integer[4], Integer[10], Integer[285], Integer[12], Integer[1], Integer[42], Integer[0], Integer[0], Integer[0], Integerdte="10/12":fdw=7:fwy=3[10/12], String[DatePart(ivl,dte,fdw,fwy)], String[2019], Integer[4], Integer[10], Integer[285], Integer[12], Integer[1], Integer[41], Integer[0], Integer[0], Integer[0], Integerdte="100000":fdw=7:fwy=3[100000], String[DatePart(ivl,dte)], String[2173], Integer[4], Integer[10], Integer[287], Integer[14], Integer[5], Integer[42], Integer[0], Integer[0], Integer[0], Integerdte="100000":fdw=7:fwy=3[100000], String[DatePart(ivl,dte,fdw)], String[2173], Integer[4], Integer[10], Integer[287], Integer[14], Integer[6], Integer[42], Integer[0], Integer[0], Integer[0], Integerdte="100000":fdw=7:fwy=3[100000], String[DatePart(ivl,dte,fdw,fwy)], String[2173], Integer[4], Integer[10], Integer[287], Integer[14], Integer[6], Integer[41], Integer[0], Integer[0], Integer[0], Integerdte=10:fdw=7:fwy=3[10], Integer[DatePart(ivl,dte)], String[1900], Integer[1], Integer[1], Integer[9], Integer[9], Integer[3], Integer[2], Integer[0], Integer[0], Integer[0], Integerdte=10:fdw=7:fwy=3[10], Integer[DatePart(ivl,dte,fdw)], String[1900], Integer[1], Integer[1], Integer[9], Integer[9], Integer[4], Integer[2], Integer[0], Integer[0], Integer[0], Integerdte=10:fdw=7:fwy=3[10], Integer[DatePart(ivl,dte,fdw,fwy)], String[1900], Integer[1], Integer[1], Integer[9], Integer[9], Integer[4], Integer[1], Integer[0], Integer[0], Integer[0], Integerdte="10 Dec":fdw=7:fwy=3[10 Dec], String[DatePart(ivl,dte)], String[2019], Integer[4], Integer[12], Integer[344], Integer[10], Integer[3], Integer[50], Integer[0], Integer[0], Integer[0], Integerdte="10 Dec":fdw=7:fwy=3[10 Dec], String[DatePart(ivl,dte,fdw)], String[2019], Integer[4], Integer[12], Integer[344], Integer[10], Integer[4], Integer[50], Integer[0], Integer[0], Integer[0], Integerdte="10 Dec":fdw=7:fwy=3[10 Dec], String[DatePart(ivl,dte,fdw,fwy)], String[2019], Integer[4], Integer[12], Integer[344], Integer[10], Integer[4], Integer[49], Integer[0], Integer[0], Integer[0], Integerdte=#9:08:51 PM#:fdw=7:fwy=3[9:08:51 PM], Date[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[21], Integer[8], Integer[51], Integerdte=#9:08:51 PM#:fdw=7:fwy=3[9:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[21], Integer[8], Integer[51], Integerdte=#9:08:51 PM#:fdw=7:fwy=3[9:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[21], Integer[8], Integer[51], Integerdte=#9:08:51#:fdw=7:fwy=3[9:08:51 AM], Date[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[9], Integer[8], Integer[51], Integerdte=#9:08:51#:fdw=7:fwy=3[9:08:51 AM], Date[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[9], Integer[8], Integer[51], Integerdte=#9:08:51#:fdw=7:fwy=3[9:08:51 AM], Date[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[9], Integer[8], Integer[51], Integerdte=#21:08:51#:fdw=7:fwy=3[9:08:51 PM], Date[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[21], Integer[8], Integer[51], Integerdte=#21:08:51#:fdw=7:fwy=3[9:08:51 PM], Date[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[21], Integer[8], Integer[51], Integerdte=#21:08:51#:fdw=7:fwy=3[9:08:51 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[21], Integer[8], Integer[51], Integerdte="21:08:51":fdw=7:fwy=3[21:08:51], String[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[21], Integer[8], Integer[51], Integerdte="21:08:51":fdw=7:fwy=3[21:08:51], String[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[21], Integer[8], Integer[51], Integerdte="21:08:51":fdw=7:fwy=3[21:08:51], String[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[21], Integer[8], Integer[51], Integerdte=#21:08#:fdw=7:fwy=3[9:08:00 PM], Date[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[21], Integer[8], Integer[0], Integerdte=#21:08#:fdw=7:fwy=3[9:08:00 PM], Date[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[21], Integer[8], Integer[0], Integerdte=#21:08#:fdw=7:fwy=3[9:08:00 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[21], Integer[8], Integer[0], Integerdte=#21:0#:fdw=7:fwy=3[9:00:00 PM], Date[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[21], Integer[0], Integer[0], Integerdte=#21:0#:fdw=7:fwy=3[9:00:00 PM], Date[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[21], Integer[0], Integer[0], Integerdte=#21:0#:fdw=7:fwy=3[9:00:00 PM], Date[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[21], Integer[0], Integer[0], Integerdte=Null:fdw=7:fwy=3[], Null[DatePart(ivl,dte)], String[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Nulldte=Null:fdw=7:fwy=3[], Null[DatePart(ivl,dte,fdw)], String[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Nulldte=Null:fdw=7:fwy=3[], Null[DatePart(ivl,dte,fdw,fwy)], String[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Null[], Nulldte=Empty:fdw=7:fwy=3[], Empty[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[0], Integer[0], Integer[0], Integerdte=Empty:fdw=7:fwy=3[], Empty[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[0], Integer[0], Integer[0], Integerdte=Empty:fdw=7:fwy=3[], Empty[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[0], Integer[0], Integer[0], Integerdte=0:fdw=7:fwy=3[0], Integer[DatePart(ivl,dte)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[7], Integer[52], Integer[0], Integer[0], Integer[0], Integerdte=0:fdw=7:fwy=3[0], Integer[DatePart(ivl,dte,fdw)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[53], Integer[0], Integer[0], Integer[0], Integerdte=0:fdw=7:fwy=3[0], Integer[DatePart(ivl,dte,fdw,fwy)], String[1899], Integer[4], Integer[12], Integer[364], Integer[30], Integer[1], Integer[52], Integer[0], Integer[0], Integer[0], Integer
Previous Month  MAR  2018  Next Month
SMTWTFS
123
45678910
11121314151617
18192021222324
25262728293031

Previous Month  JUN  2014  Next Month
SMTWTFS
1234567
891011121314
15161718192021
22232425262728
2930

Sideway BICK Blog

23/03

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