My rpt access dates from an SP.

When the SP is run interactively,
the dates are returned as Nulls, or YYYY-MM-DD HH:MM:SS.DDD   (e g 2008-01-22 00:00:00.000)

I created a formula :

If isnull({Date})
    Then " "
else
    ToText({Date}, "yyyy-mon-dd")


The ISNULL works OK, but if there is a date,
as above, I get
2008-0on-22, instead of 2008-Jan-22.

Many thanks Rahul : so obvious !