forums

Use these forums to ask questions and discuss Tableau.

replacing dates with Null values with values of another date variable

Posted November 22nd, 2007 by gbretas
in Calculations

What is the syntax for replacing dates with Null values with values of another date variable

Add new comment

Comments

On November 26th, 2007 Ross Bunker said:

The ISNULL and IIF functions will help you do this.
Typically, you'll do IIF(ISNULL([Date1]),[Date2],[Date1])

which reads:
'If Date1 is null, use Date2 otherwise, use Date1'

reply