543026_en-US

liliconcom

Subtracting number of hours from Date and time

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

Automation and ScriptingRe: Subtracting number of hours from Date and time

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";