View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raul Raul is offline
external usenet poster
 
Posts: 86
Default Rounding Up a Timestamp

I'm querying a database and the timestamp is coming back to the routine as:
12-04-2005 00:59:59.

I'd like the output the user sees to be 12-04-2005 01:00.

Is there a way to "roundup" a date to the next highest minute.

by the way, I'm using ADO and the data retrieved from the query is being
placed in an array with data type = string and the timestamp string is
converted to a date using CDate prior to being placed in the array.

Thanks in advance,
Raul