help with expression

[arusanah]

=Date(Date#(left(subfield('ABC_Sept2016','_',2),8),'MMMYYYY'),'MMM YYYY')

expression is throwing me error not returning anything . The outer DATE() is not working . I used exactly same expression for other file it works perfectly fine . but for this one till Date#()  it is working fine but outer Date() throwing error .pls help

[sunny_talwar]

Your month is 4 letters, rather than the normal three letters?

Sept vs Sep... Did you change the environmental variable accordingly?

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sept;Oct;Nov;Dec';

[arusanah]

yes I had already done that , but your  observation still help me find my mistake .a very minute error in my expression ..

thanks again sunny boy

[antoniotiman]

add to the Sunny's answer, try

Alt(Date(Date#(subfield('ABC_sept2016','_',2),'MMMYYYY'),'MMM YYYY'),
Date(Date#(subfield('ABC_sept2016','_',2),'MMMMYYYY'),'MMM YYYY'))

Regards

Antonio

[sunny_talwar]

It might be helpful if you can share what error were you making as it might help someone else in the future to not repeat the same error?

Thanks,

Sunny