Re: DatePart
From: Bob Hairgrove <wouldnt_you_like_at_to_know.com>
Date: Fri, 20 Feb 2004 14:38:39 +0100
Message-ID: <d93c309u0o59f19lni3kf5do0jp0h6274q_at_4ax.com>
Date: Fri, 20 Feb 2004 14:38:39 +0100
Message-ID: <d93c309u0o59f19lni3kf5do0jp0h6274q_at_4ax.com>
On Fri, 20 Feb 2004 03:24:38 GMT, "mountain man"
<hobbit_at_southern_seaweed.com.op> wrote:
MSAccess also has a DatePart() function. However, it's not portable
>The original post specified the *datepart()* function.
>This is a standard function in SQL server.
So maybe not everyone uses SQL Server, either. I tried to suggest a solution which (except for the #...#) would work in other environments as well.
-- Bob Hairgrove NoSpamPlease_at_Home.comReceived on Fri Feb 20 2004 - 14:38:39 CET