你想看一下CDate函数。

You''ll want to take a look at the CDate function.

我不确定你是否需要使用CDate（）兔子。 Access如何处理这些日期的事情是如此古怪，但只是做了

YourNewField = YourShortDate& " " &安培; YourLongTime

看起来很好。然后，您可以在DateAdd和DateDiff等日期功能中使用结果，没有问题。


欢迎来到TheScripts，新海报！


Linq ; 0）>

I''m not sure you need to use CDate() Rabbit. How Access handles these date things is so quirky, but simply doing

YourNewField = YourShortDate & " " & YourLongTime

seems towork just fine. You can then use the results in Date oriented functions, such as DateAdd and DateDiff, without problems.

Welcome to TheScripts, New Poster!

Linq ;0)>

Thanx Rabbit和Linq。它运作得很好。 dateDiff是锦上添花！

Thanx Rabbit and Linq. It worked great. dateDiff was the icing on the cake!