Null value in date field.

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.

I find the solution

IF DATEFIELD == datenull()

Compare the datefield as,

if(table.datefield == datenull())

Just try,it will work definitely.

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.

try this

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