How to Import Null Date Values?

[joscetre]

I have an API call which sends data to Caspio. One of the fields sent is a date, but it is an optional field, so is sometimes null. The API call rejects a null value for a date field. If I send a zero or blank value the date shows in Caspio as 01/01/1900. Is there a way to avoid this?

[ShWolf]

Hi

Try to pass 'null' value without single quotes to the date field.

Let me know if this helps.

[joscetre]

Yes, that worked! And I thought I had tried everything.

Thanks for your help