Categories
Dynamics NAV HOW TO Microsoft

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

[sourcecode lang=”Cside”]
TESTFIELD("Starting Date Formula",ZeroDateFormula);
[/sourcecode]

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.

[sourcecode lang=”Cside”]
IF PeriodLength = ZeroDateFormula THEN
ERROR(Text001);
[/sourcecode]

Did my HOW TO help you? Leave a reply.