Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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
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';
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
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
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