coalesce Error
please input error: conversion failed when converting datetime character string .... close coalesce select (t1.first_name + ' ' + t1.last_name + '(' + t1.work_status + ')' ) name , t1.eid , t1.csgid , t1.ccfrole , t1.ccflocationid , t1.modifydate updated --, t1.logindate --, t2.lastlogin , coalesce ( coalesce (t2.lastlogin, t1.logindate), 'never' ) as [logged in ] --, t1.ccflevelid --, t2.securitylevel_id from ccfuser t1 left outer join user_tbl t2 on t1.first_name = t2.first_name and t1.last_name = t2.last_name where t1.ccflevelid in (2, 4) , t1.deleted = 0 all choices in coalesce have same datatype. use whatever db function available convert 1st 2 choices date string. More discussions in Database Access adobe