topic Subtract 1 hour from 00:00 time so that the Date could also be changed in Discussions

Subtract 1 hour from 00:00 time so that the Date could also be changed

chandankishor66 — Fri, 09 Jun 2023 16:04:31 GMT

Hello JMP community,

Is there any way to subtract 1 hour from 00:00 time so that the Date could also be converted to the previous data?

For example:

The input table is Expected Output should be

Any suggestions would be highly appreciated.

Regards

Re: Subtract 1 hour from 00:00 time so that the Date could also be changed

txnelson — Sun, 11 Dec 2022 13:02:13 GMT

Here is how I would do it

Names Default To Here( 1 );
dt = Current Data Table();
For Each Row(
	datetime = :date + 60 * 60 * Hour( :time ) + 60 * Minute( :time );
	datetime = datetime - In Hours( 1 );
	:new time = Hour( datetime ) * 60 * 60 + Minute( datetime ) * 60;
	:new date = Date MDY( Month( datetime ), Day( datetime ), Year( datetime ) );
);