Format of _Modified System Field

[reytheist]

I am currently exporting the data from a discussion tool into InfoPath, and I
am having issues getting InfoPath to properly format the integer provided by
Groove's export on the _Modified field. In what format does Groove store
dates in XML?

 

[Mark Smith]

Hi reytheist -

There's an article about how Groove exports dates here:

http://infopatterns.com/faq/groove/forms/exportdatefields

 

[reytheist]

Thank you, Mark. I feel like I'm closer, but not quite there yet.

I'm not sure if I mentioned, but I am using Groove 2007.

I am trying to convert the _Modified field into something useable. I created
a hidden text field called "ExportingModifiedDate" then added the following
lines of script to the OnBeforeSubmitData() function.

try {
var dateValue = new Date(GetField("_Modified"));
var dateString = GetApp().FormatDateTime(dateValue.valueOf(), 3, 3 );
SetField("ExportingModifiedDate", dateString);
}
catch(err) {
alert("Error in exporting date value: " + err.description);
}

Unfortunately, this returns "Error in exporting date value: Object expected".

Thanks again for your assistance.

Rey