Prev: id is not an index in this table
Next: linking tables from different Access templates?
From: James A. Fortune on 19 Mar 2010 16:15
On Mar 17, 8:12 pm, "KenSheridan via AccessMonster.com" <u51882(a)uwe>
wrote:
> The following function would round a date/time value down to the nearest hour:
>
> Public Function RoundToHour(dtmDateTime As Date) As Date
>
>     RoundToHour = CDate(Format(dtmDateTime, "yyyy-mm-dd hh:00:00"))
>
> End Function
>
> Ken Sheridan
> Stafford, England

That's a very nice, elegant function!

James A. Fortune
MPAPoster(a)FortuneJames.com
From: KenSheridan via AccessMonster.com on 19 Mar 2010 16:58
Kind of you to say so, James.

Ken Sheridan,
Stafford, England

James A. Fortune wrote:
>On Mar 17, 8:12 pm, "KenSheridan via AccessMonster.com" <u51882(a)uwe>
>wrote:
>> The following function would round a date/time value down to the nearest hour:
>>
>[quoted text clipped - 6 lines]
>> Ken Sheridan
>> Stafford, England
>
>That's a very nice, elegant function!
>
>James A. Fortune
>MPAPoster(a)FortuneJames.com

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2 3
Prev: id is not an index in this table
Next: linking tables from different Access templates?