cancel
Showing results for 
Search instead for 
Did you mean: 

Null date subtraction

former_member182342
Active Contributor
0 Kudos

In my report, data for one date value is '0/0/00'. but when i drag and drop into report panel it showing blank.Pls reply me.

and if i substract any other date from blank date it showing 0 value.Pls reply my question . waiting for ur reply.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member292966
Active Contributor
0 Kudos

Hi,

If you need to deal with a NULL date, use Date (0, 0, 0) to check if the date is NULL or not first.

So your formula would look something like:

If {table.Date1} = Date (0, 0, 0) Then 
     {table.Date2} 
Else {table.Date1} - {table.Date2};

Thanks,

Brian