Reply to comment
In this example:
-
your billing account is set to use PST
-
you have a table where field 7 is a DTM field
If you issue this API call without using the msInUTC parameter:
?a=API_AddRecord&_fid_7=1267642263823
…QuickBase interprets the value for field 7 as milliseconds in PST. If you then display the record you added, QuickBase displays this value: 03-03-2010 06:51 PM . (The display is always in application local time).
If instead you include the msInUTC parameter and issue this API call:
?a=API_AddRecord&_fid_7=1267642263823&msInUTC=1
…Quickbase interprets the value for field 7 as milliseconds in UTC. If you then display the record you added, QuickBase displays this value:03-03-2010 10:51 AM
- Add new comment
- 28195 reads
