on 04-03-2011 8:51 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.