Cleanest way to add a second to date/time?

[Lee_Jay]

I have a bunch of singles with the date and time in them from year down to tenths of milliseconds.  I want to add 1 second and have the rest update.  This is the cleanest way I've come up with.  I'm not too fond of the bundling and unbundling but I can't think of another way.  Anyone have an easier/faster/cleaner way?

Lee Jay

[TCPlomp]

Hi Lee Jay,

do you have to use this format (splitted into several data types)?
Because the time stamp format is easier to handle (and you could easily add 1 second). With the formatting variaty you can almost do everything with timestamps.

Ton

[Lee_Jay]

Yes, I must use the split-out format.

Lee Jay

[johnsold]

Lee Jay,

If the original value of Seconds = 59, does your code do what you want? You may need to propagate overflow throughout the cluster.

Lynn

[Lee_Jay]

Yes, the whole point of doing this is to get minutes, hours etc. to roll over properly.  And this code does work for that.

Lee Jay

[Lee_Jay]

By the way, adding 1 after the conversion works the same.

Lee Jay

[BEHajder]

Maybe I'm missing something, but isn't just adding 1 second like in the attached example what you want to do?

[Lee_Jay]

That's exactly what I'm doing, but I have to start and end with each component of time/date in individual singles.

Lee Jay

[Mcdan]

Lee_Jay,

I think all that you really need to do is add 1 to your timestamp.  I've attached a quick example.

Hope this helps,
Dan

[Lee_Jay]

I don't have a time stamp.  I have 7 singles and I need to end up with 7 singles.  That's the problem.

Lee Jay