我在读Excel的时候想把Excel中的一个存放时间的列直接在查询中处理成周数,语句是:
IIF(CDATE(F15),0,DATEPART(\"WW\",CDATE(F15)))
但是会出现错误,错误信息:
The provider could not determine the Int32 value. For example, the row was just created, the default for the Int32 column was not available, and the consumer had not yet set a new Int32 value.
哪位大虾帮忙解决下~