I am having trouble try to get my IIF to evaluate true with the following formula. Anyone have an idea? Eq(DateTimeFormat(ENDDATE,"yyyy-MM-ddTHH:mm:ss.000"),DateTimeFormat("1900-01-01 00:00:00.000","yyyy-MM-ddTHH:mm:ss.000")) I need to replace any occurance of "1900-01-01 00:00:00.000" with a blank string or NULL. IIF(Eq(DateTimeFormat(ENDDATE,"yyyy-MM-ddTHH:mm:ss.000"),DateTimeFormat("1900-01-01 00:00:00.000","yyyy-MM-ddTHH:mm:ss.000")),"",ENDDATE)

You can use the Word function, which returns a word in a string. I belief, this should do the trick: Word((DateTimeFormat(ENDDATE,"yyyy-MM-ddTHH:mm:ss.000"), 1, "T") Cheers, MarkusMarkus Vilcinskas, Knowledge Engineer, Microsoft Corporation

That worked! You just have an extra "(" next to "Word". Thanks!