topic Re: Subtracting number of hours from Date and time in Discussions

Subtracting number of hours from Date and time

chandankishor66 — Fri, 09 Jun 2023 15:58:11 GMT

HI,

I want to subtract 6 hrs in 05-07-2022 01:00 so final value should be 04-07-2022 19:00
Can you please suggest me how perform this calculation in JMP16.

Many thanks

Re: Subtracting number of hours from Date and time

txnelson — Sat, 10 Sep 2022 05:00:53 GMT

Use the In Hours() function

Date = Informat( "05/07/2022 01:00:00", "m/d/y h:m:s" );
New Date = Date - In Hours( 6 );
Show( Format( New Date, "m/d/y h:m:s" ) );

Displays

Format(New Date, "m/d/y h:m:s") = "05/06/2022 7:00:00 PM";