# Null value in date field.

**URL:** <https://www.dynamicsuser.net/t/null-value-in-date-field/31104>\
**Category:** Developer Forum\
**Created:** [May 25, 2011, 9:52am UTC](https://www.dynamicsuser.net/t/null-value-in-date-field/31104 "2011-05-25T09:52:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dev1978](https://avatars.discourse-cdn.com/v4/letter/d/edb3f5/32.png) [@Dev1978](https://www.dynamicsuser.net/u/Dev1978)\
**Post date:** [May 25, 2011, 9:52am UTC](https://www.dynamicsuser.net/t/null-value-in-date-field/31104/1 "2011-05-25T09:52:37Z")

</div>

I want to check for a field type date at the form entry level that if the user leave this field blank then it should raise an error. Although i have made it mandatory = YES but still when i click the button it did not check it. it will only work if i also modify any other field on the same block then click this button.

i am writing this condition to check the null

**if table.datefield == ''**

it is not working

plz help.

---

<div class="post-metadata">

**Author:** ![Dev1978](https://avatars.discourse-cdn.com/v4/letter/d/edb3f5/32.png) [@Dev1978](https://www.dynamicsuser.net/u/Dev1978)\
**Post date:** [May 25, 2011, 10:12am UTC](https://www.dynamicsuser.net/t/null-value-in-date-field/31104/2 "2011-05-25T10:12:48Z")

</div>

I find the solution

IF DATEFIELD == **datenull()**

---

<div class="post-metadata">

**Author:** ![Ramyasrilakshmi](https://avatars.discourse-cdn.com/v4/letter/r/df705f/32.png) [@Ramyasrilakshmi](https://www.dynamicsuser.net/u/Ramyasrilakshmi)\
**Post date:** [May 26, 2011, 6:00am UTC](https://www.dynamicsuser.net/t/null-value-in-date-field/31104/3 "2011-05-26T06:00:36Z")

</div>

Compare the datefield as,

if(table.datefield == datenull())

Just try,it will work definitely.

---

<div class="post-metadata">

**Author:** ![kollinaresh.k](https://avatars.discourse-cdn.com/v4/letter/k/f475e1/32.png) [@kollinaresh.k](https://www.dynamicsuser.net/u/kollinaresh.k)\
**Post date:** [May 26, 2011, 8:21am UTC](https://www.dynamicsuser.net/t/null-value-in-date-field/31104/4 "2011-05-26T08:21:52Z")

</div>

Hi Kami,

In the table level for the date field if make it as mandatory = YES it will work.Can you tell how you did.

Naresh Kolli.

---

<div class="post-metadata">

**Author:** ![angelus](https://avatars.discourse-cdn.com/v4/letter/a/f05b48/32.png) [@angelus](https://www.dynamicsuser.net/u/angelus)\
**Post date:** [May 8, 2014, 8:43am UTC](https://www.dynamicsuser.net/t/null-value-in-date-field/31104/5 "2014-05-08T08:43:11Z")

</div>

try this

table.DateField=str2Date(“1900-01-01”,1)