Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
How to set date field to NULL and get it accepted on POST or PATCH — Cloud Customer Connect
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
50
Views
3
Comments
edited Jun 8, 2022 12:07PM in General Technical Discussions 3 comments

Summary

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

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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