DataError Event Fired on Expression DataColumn Using FORMAT()

[Ryan0827]

I assign the expression below to a DataColumn.Expression. If cell in column clmOrders_ProjectedInvoiceDate is NULL DataError event is fired saying "An error has occurred while executing function AddDays(). How can I avoid this error?

FORMAT("{0:d}",ADDDAYS(clmOrders_ProjectedInvoiceDate,-33))


Ryan

Continue reading...