For future reference you just need to make the fields the same data type:
if isnull ({table.datetimefield}) then 'Open Incident'
else totext({table.datetimefield})
You can also further define the way the string appears by adding that as a condition in the totext() conversion. As an example...
totext({table.datetime},'dd/MM/yy h:mm:ss tt')
Edited by DBlank - 14 Apr 2010 at 3:43am
IP Logged
