about cal datetime..

[#1]

hello.


col1 : 2024-07-12 14:21:33
col2 : 333
cal_col3 : 2024-07-12 19:54:33

“How can I calculate the date and time in Col3 by adding the minutes specified in Col2 to the date and time in Col1 in JMP?

For example, if Col1 contains 2024-02-01 14:21:33 and Col2 contains 333, I want Col3 to show 2024-02-01 19:54:33

[#2]

Hi,

You can use the "Date Increment" function to calculate what you need (see below)

Date Increment( :Col1, "Minute", :Col2)

Best,

TS

[#3]

If your col1 is a character column and not a JMP numeric DateTime column you will need to use this formula for the calculation

Date Increment(
	Informat( :col1, 
		"Format Pattern", "<YYYY><-><MM><-><DD><hh><:><mm><:><ss>" ),
	"Minute",
	:col2
)