How do I convert a timestamp to a duration format?

WHG — Fri, 08 Nov 2019 12:46:51 GMT

I would like to convert a column containing timestamp data in the numeric "ddMonyyyy h:m:s" time format to a numeric time duration format in seconds, starting the duration in the first row of my datatable.

Re: How do I convert a timestamp to a duration format?

ron_horne — Fri, 08 Nov 2019 13:10:24 GMT

Hi @WHG

try the following script

otherwise you can do it manually using the same functions

names default to here (1);
dt = current data table ();
dt << New Column( "Duration",
		Numeric,
		"Continuous",
		Format( "Best", 12 ),
		Formula(
			Date Difference(
				:Date of Observation[1],
				:Date of Observation,
				"second"
			)
		)
	);

let us know if it works

topic How do I convert a timestamp to a duration format? in Discussions

How do I convert a timestamp to a duration format?

Re: How do I convert a timestamp to a duration format?