remove unwanted character from list box

[renjithpl]

Hi All,

Here follows my coding to get day format like this : 12-Tue-Oct 2010

Day([Date Coded])&'-'&weekDay([Date Coded])&'-'&MonthName([Date Coded]) as Day,

I am showing day field in a list box.

but i am getting some null value

How can i eliminate it.?

Thanks in advance

[#2 · Accepted solution]

Check first of your Date Coded field has a value!

IF(NOT ISNULL([Date Coded]),
Day([Date Coded])&'-'&weekDay([Date Coded])&'-'&MonthName([Date Coded]),
NULL()) as Day

[renjithpl]

Thanks Sander, its eliminated now.