BusinessObjects Board

[SOLVED]DS 4.1: substr within ifthenelse

dataservices data quality
#1

Validation throws an error when I do something like this:

ifthenelse(substr("21359_CHECKNUM_APPEND"."Check Issue Date",6,7) = '01','JANUARY',NULL)

I’m trying to change a date from format 2013.01.28 to JANUARY 28, 2013. Anyone know a good way to do this?

EDIT: oops. I was trying to use the substr function on a DATE data type. Problem solved.

DanHosler :us: (BOB member since 2013-06-19)