Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Sander, its eliminated now.