你可能感兴趣的试题
Mid Day(date) Month(date) Year(dat
Day(DD) Day(DateSerial(Year(DD),Month(DD),Day(DD)) Day(DateSerial(Year(DD),Month(DD),0)) Day(DateSerial(Year(DD),Month(DD)+1,0))
Mid Day(date) Month(date) Year(date)
Day(DD) Day(DateSerial(Year(DD) ,Month(DD) ,day(DD) )) Day(DateSerial(Year(D ,Month(DD) ,0))D) Day(DateSerial(Year(DD) ,Month(DD) +1,0))
Day(D Day(DateSerial(Year(D,Month(D,day(D)) Day(DateSerial(Year(D,Month(D,0)) Day(DateSerial(Year(DD),Month(DD)+1,0))
Day(DD) Day(DateSerial(Year(DD),Month(DD),Day(DD))) Day(DateSerial(Year(DO),Month(DD),0)) Day(DateSerial(Year(DD),Month(DD)+1,0))
Day(DD) Day(DateSerial(Year(DD),Month(DD),Day(DD))) Year(DD) Day(DateSerial(Year(DD),Month(DD)+1,0))
两个日期型数据可以相加,即得到一个新的日期。 两个日期型数据可以相减,得到两个日期相差的天数。 日期型可以和整数型数据相加,得到一个新的日期。 日期型可以和整数型数据相减,得到一个新的日期。
Day(DD) Day (Date Serial(Year(DD) Month(DD) ,day(DD) )) Day (Date Serial(Year(D Month(DD),0))D) Day(Date Serial(Year(DD) ,Month(DD)+1,0))
Month(8) Day(8) Month(dat Week(8)
Day(DD) Day(DateSerial(Year(DD) ,Month(DD) ,day(DD) )) Day(DateSerial(Year(D ,Month(DD) ,0))D) Day(Da teSerial(Year(DD) ,Month(DD) +1,0))
Mid Day(date) Month(date) Year(dat
Month(8) Day(8) Month(date) Week(8)
Day(D Day(DateSerial(Year(D,Month(D,Day(D)) Year(D Day(DateSerial(Year(D,Month(D+1,0))
Day(D Day (Date Serial(Year(D Month(D ,day(D )) Day (Date Serial(Year(D Month(D,0)) Day(Date Serial(Year(D ,Month(D +1,0))
Day(D Day(DateSerial(Year(D ,Month(D ,day(D )) Day(DateSerial(Year(D ,Month(D ,0)) Day(Da teSerial(Year(D ,Month(D +1,0))
Day(D Day(DateSerial(Year(D ,Month(D ,day(D )) Day(DateSerial(Year(D ,Month(D ,0)) Day(DateSerial(Year(DD) ,Month(DD) +1,0))