MS Access . .
( MS Access MS Excel) MS Access MS Excel. , .
P + . P0, .
ComplSheet ( ) ComplSheet!RGN_Data MS Access .
Report.mdb ,
- -
.
. . , , .
,
/ (DATE/TIME)
, / (Date/Time) | |
Date | . Variant. : Date() |
DateAdd | Variant, / . : DateAdd(, , ) : ; , , . ; , ; , . ; Variant (Date) /, . : ; q ; ; ; d ; w ; ww ; h ; ; s . . , 31--95 1 , 28--95, 31--95. : DateAdd("d",30,Date) 30 . DateAdd("ww",-l,Date) . |
DateDiff | Variant (Long), . : DateDiff(, dama1, 2 [, __ [, __ ]]) . : ; , . 1 2 , / (Date/ Time), . __ , : , (Sunday). __ , ; , 1 . , DateAdd. __:vbUseSystem ; vbSunday ( ); vbMonday ; vbTuesday ; vb Wednesday ; vbThursday ; vbFriday ; vbSaturday . __: VbUseSystem ; vbFirstJan1 , 1 ( ); vbFirstFourDay , 4 ; vbFirstFullWeek . : DateDiff("ww",#01.01.98#,Date) , 1 1998 . |
DatePart | Variant (Integer), . : DatePart(, [, __ [, __ ]]) DateDiff. : DatePart("q", Date) . |
DateSerial | Variant (Date), , . : DateSerial(, , ) , , . : DateSerial(1999, 1, 1) #01.01.99*. |
DateValue | Variant (Date). : DateValue() , /. . : DateValue(" 1, 1999") #01.01.99# |
Day | Variant (Integer), . : Day(), , . Null, Day Null. : Day(#12.02.99#) 12. |
Month | Variant (Integer), . : Month() : Month(#12.02.99#) 2. |
Now | Variant (Date), . : Now() |
Year | Variant (Integer), , . : Year() : Year(" 12, 1999") 1999. |
Hour, Minute, Second | , . : Hour (), Minute(), Second() , . : Second(#18:20:50#) 50. |
Time | Variant (Date), . : Time() |
TimeSerial | , , . : TimeSerial(, , ) . : TimeSerial(18, 20, 50) #18:20:50#. |
TimeValue | , . : TimeValue() ( ), . : TimeValue("4:35:17 ") #16:35:17#. |
|
|
|
|