>>>How can I convert datetime() to the nearest hour?
>>
>>Try:
>>
>>lnHour = ROUND(HOUR(DATETIME()) + MINUTE(DATETIME()),0)
>
>I figured this out:
>
ltTimeToReschedule = DATETIME()
lnMinutes = MINUTE(m.ltTimeToReschedule)
lnMinutes = lnMinutes - FLOOR(MINUTE(m.ltTimeToReschedule)/15)*15
lnSeconds = SEC(m.ltTimeToReschedule)
ltTimeToReschedule = m.ltTimeToReschedule + (15-m.lnMinutes) * 60 - m.lnSeconds
=MESSAGEBOX(m.ltTimeToReschedule)
It should have been:
lnHour = ROUND(HOUR(DATETIME()) + MINUTE(DATETIME())/60 + SEC(DATETIME())/3600,0)
To account for the minutes are 60 per hour (minutes divided by 60). The above returns hour in 'military', i.e., 6pm is 18. This returns the closes hour to the datetime value.