Thank you for providing such a rich resource.
I am having some great success with my initial use of the API, but I am really struggling with the Date format.
If I write to a column just the date via the API and then use a second column with the ToDate() gormula it works, but if I add time to the data I have no success.
I also cannot write directly to a date field and have the data recognised as a date.
My questions are:
- Is it possible to write directly to a date field via the API? If so, what is the format expected?
- If the above is possible, how should a date and time format be formatted so it is recognised? Also, does the ToDate() formula recognise Time and Date?