How to add DateTime to the new record?

[Muralik2]

I want to add DateTime to newRecord[0] = DateTime.Now;
Which is not working, in valid cast error?

[rossdonald]

In SPSS DateTime seems to be stored as number of seconds from start of the Gregorian calendar.

So you can use a function like this to calculate the value:

double GetSpssDateTimeValue(DateTime value)
{
	// SPSS uses this date as its zero date
	DateTime epocStart = new DateTime(1582, 10, 14, 0, 0, 0, DateTimeKind.Unspecified);

	return value.Subtract(epocStart).TotalSeconds;
}

Then use code like this to set the variable value:

newRecord[0] = GetSpssDateTimeValue(DateTime.Now);

A datetime variable definition looks something like this

new Variable("StartDate")
{
	Label = "Start",
	Type = DataType.Numeric,
	Width = 20,
	PrintFormat = new OutputFormat(FormatType.DATETIME, 20),
	WriteFormat = new OutputFormat(FormatType.DATETIME, 20),
}