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)
  • JoshuaTate's avatar
    JoshuaTate
    Qrew Cadet
    8 years ago
    The difference isn't a day, the difference is the dates are being input as american so its a month out. Whats strange is the dates are fine when the day is above 12 but not lower. 
  • 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])))