302 Found

Found

The document has moved here.

Formula Function Reference

Our Formula Function Reference

Nz - Null Handling

Arguments: 
(Date x, Date y)
Result Type: 
Date
Explanation: 
This function returns x if x is not null. If it is null, it returns the alternate value y instead.--Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.-
Example: 
Nz([Actual Finish Date], [Estimated Finish Date]) returns the value in the Actual Finish Date field, if it exists. If the Actual Finish Date field is empty, this formula returns the date in the Estimated Finish Date field.
Tags:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.