You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to set date field to NULL and get it accepted on POST or PATCH

Received Response
edited Jun 8, 2022 12:07PM in General Technical Discussions 3 comments


Tried datevariable = NULL, datevariable = NULL DATE - any other suggestions?


We are passing customer information into Oracle Service Cloud.

Date fields may or may not be set depending on how far the user progressed. Other null fields are OK, just dates or times are the problem.

They are set on the database as isNullable but we can't find exactly the right syntax to set them to Null. Can anyone advise?

A back resort is to set them to some date date/time in 1970 but that won't really help the stats. An empty date should be empty.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!