I'm having a problem inserting a date into the Date field. The formatting seems to be correct, but I'm assuming it's not working because the date I'm entering into the Date data type field is a string.
Here's what I'm entering for the Date field:
Qt.formatDateTime(new Date(), "M/d/yyyy hh:mm:ss AP");
But when I sync the data, it says everything is successful, but the field is Null. How can I get my local date / time into the Date field? I know Editor Tracking can accomplish this, and I do have it turned on, but I'd like to figure this out.
What do I need to do?