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
AnnaRayner's avatar
AnnaRayner
Qrew Member
7 years ago
In the template you create to use with Exact Forms Plus, replace the use of ~x~ where x is the relevant field id with:

~d#f#dd/MM/yyyy~

Put the field ID in place of the x and the date should come out in the correct format.