Forum Discussion

JoshuaTate's avatar
JoshuaTate
Qrew Cadet
8 years ago

API_addrecord copying date in wrong format to new record

Hi QB Community, We are using an API Call to create a new work package record using data from a SOW record, date on newly created work package appears to have pasted the date in American format or ...
APIs and custom code
Ask about Quickbase functionality
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
You have to account for the time zone of the data center when using the API, and have to convert to unix time as well. 

Otherwise you get the day difference depending on if it runs early morning or late evening.

(Yes I know, its ridiculous)
PaulVorster1's avatar
PaulVorster1
Qrew Cadet
7 years ago
HI Joshua, i had the same problem, and this formula resolved my problem...

"&_fid_34=" & Right("0"&ToText(Day(ToDate([Current Date and Time]))),2) &"-" & Right("0"&ToText(Month(ToDate([Current Date and Time]))),2) &"-"& ToText(Year(ToDate([Current Date and Time]))) &" "& ToText(Hour(ToTimeOfDay([Current Date and Time]))) &":"& ToText(Minute(ToTimeOfDay([Current Date and Time])))