help with Expression

[arusanah]

Date(Date#(left(subfield(FileName("AB_CD_EF_GH_IJ_KL_Monthly_SEPTEMBER_2016.xlsx"),'_',8),8),'MMMYYYY'),'MMM YYYY')

i'm trying to generate new field  from a above file name , which  should have sept 2016 as value. my expression throws error . can somebody help me here .

[sunny_talwar · Accepted solution]

Try this may be:

=MonthName(Date#(Capitalize(

Subfield('AB_CD_EF_GH_IJ_KL_Monthly_SEPTEMBER_2016.xlsx', '_', 8)) & '-' &

SubField(Subfield('AB_CD_EF_GH_IJ_KL_Monthly_SEPTEMBER_2016.xlsx', '_', 9), '.', 1), 'MMMM-YYYY'))

Or

=MonthName(Date#(Capitalize(

Subfield(FileName(), '_', 8)) & '-' &

SubField(Subfield(FileName(), '_', 9), '.', 1), 'MMMM-YYYY'))

[arusanah]

Thank you Sunny !!!

[sunny_talwar]

No problemo