HOW TO test if a DateFormula variable is empty

We can learn a lot reading Microsoft standard C/AL code.

HOW TO test if a DateFormula variable is empty?

An example is offered in the Table 5088 Profile Questionnaire Line

TESTFIELD("Starting Date Formula",ZeroDateFormula);

Solution:
Create a Global Variable named like ZeroDateFormula of DataType DateFormula and don’t assign any value to it.

Now you can use this variable to test if a DateFormula variable is empty.

IF PeriodLength = ZeroDateFormula THEN
  ERROR(Text001); 

Did my HOW TO help you? Leave a reply.

Exception from HRESULT 0x800AC472

Microsoft Dynamics NAV
—————————

Exception from HRESULT: 0x800AC472
—————————
OK
—————————

Exception from HRESULT 0x800AC472

Exception from HRESULT 0x800AC472

Solution:
Activate Microsoft Office Excel inserting the Product Key then close and reopen it.

Did my solution solve your problem? Leave a comment.