What date format does the Confiforms API return?

[Jeremiah Watkins]

I'm trying to grab info from a ConfiForms form. The date format for fields, as well as the "created date" metadata, is returned as something like this: "1661884603214".

What date format is this? I've tried converting it from binary, from file time, from epoch time--nothing is working.

I checked the Confiforms API documentation and I don't see it addressed anywhere.

So what date format is it and how would I convert it to be able to convert it to regular date time?

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Jeremiah Watkins 

This is a timestamp (https://www.unixtimestamp.com/) in milliseconds

Alex

[Jeremiah Watkins]

Thanks! I was trying to convert it from seconds. It's working now.

[Alex Medved _ConfiForms_]

Yes, sorry about that - all date/datetime values are in milliseconds as unit timestamp

(dates before the 1.Jan 1970 are negative values)

You can also ask ConfiForms to transform values if needed see "fields" parameter description in  https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Server+REST+API+version+1#ConfiFormsServerRESTAPIversion1-GetConfiFormsEntrybyID

(same parameters can be used with "search endpoint")

Alex