Not sure if you've received answer(s) on this. For Date/Time fields, the value you supply should be of AR_DATA_TYPE_TIME with an associated time value (ARValueStruct.u.timeVal) set to UNIX time stamp value (integer value, number of elapsed seconds since 1/1/1970).
For Date fields, you have to give AR_DATA_TYPE_DATE with date value (ARValueStruct.u.dateVal) as an integer representation of a Julian date. To get this value, you may want to use ARDateToJulianDate API method. For Time fields, although you did not ask for in your query, the value should be of type AR_DATA_TYPE_TIME with the time value (ARValueStruct.u.timeOfDayVal) as elapsed number of seconds since 12AM. In essence, it is of the form => seconds + (60 * (minutes + (60 * hours))) Where 0<=seconds<60, 0<=minutes<60, 0<=hours<24. To set a value to current time, you can simply set the value as AR_DATA_TYPE_KEYWORD, with value part (ARValueStruct.u.keyNum) as AR_KEYWORD_TIMESTAMP. Other variants are AR_KEYWORD_DATE, _TIME, _SERVERTIMESTAMP. Check out AR_KEYWORD_* in your ar.h for more details. Regards Appajee -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mikhail Sent: Tuesday, May 22, 2007 12:39 PM To: [email protected] Subject: C API: Setting Date/Time Value. Hello List, I have a few questions regarding setting a value for the field with data type "Date/Time" in a C API. Which one should I use? AR_DATA_TYPE_TIME? or AR_DATA_TYPE_DATE? Also how can I set it to $TODAY$ (the time and date as we speak)? An example value for the Date/Type data type would be "5/18/07 1:15:34 PM" Thanks, Mikhail ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
