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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I�m not quite sure what you are asking here, but why not just use a a formula to extract out the DD MM and YYYY from your source data by converting it to Text and parsing out the DD MM YYYY and then feeding the American Date format into the API AddRecord.

Ie, convert the data to an American Date format. Using Date(yyyy,mm,dd).