FAQ: I want to set a date item to NULL in the API
## Answer
Please set a value outside the range of the values set in the "MinTime" and "MaxTime" parameters of the "[General.json](/ja/manual/general.json)".
---
## Overview
You can update the date field to NULL by setting a value outside the range of the values set in "MinTime" and "MaxTime" of "[General.json](/ja/manual/general.json)" in the "Record Update" of Pleasanter "[API](/ja/manual/api)".
## Script
This is a script that updates date A to NULL. If "MinTime" and "MaxTime" of "[General.json](/ja/manual/general.json)" are set as follows, it will set to "1899/12/31".
MinTime: "1900/1/1"
MaxTime: "2100/1/1"
##### javascript
```
$p.apiUpdate({
id: 123456,
data: {
ApiVersion: 1.1,
DateHash: {
DateA: '1899/12/31'
}
},
done: function (data) {
console.log('success!');
console.log(data);
},
fail: function (data) {
console.log('fail...');
console.log(data);
}
});
```
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/general.json">パラメータ設定:General.json</a><span>06.12.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/api">Developer Function: API</a><span>08.14.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/extended-sql-api">Developer Function: Extensions: Extended SQL: Executing Extended SQL from the API</a><span>08.14.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/faq-api-paging">FAQ: I want to retrieve data exceeding 200 records via API</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/faq-api">FAQ: An error occurs when executing the API</a><span>08.14.2024 up</span></li>
<li><a href="/en/manual/faq-json-format">FAQ: What to check if modified configuration files or API requests (JSON format) are not recognized correctly</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />