Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi how would I load '2015-08' so that only '8' is displayed ?
Thanks
may be this as well?
=mid(FieldName, len(FieldName)-1, len(FieldName))
Hi,
try below
num(SubField(F1,'-',-1))
Regards,
try dis
= mid(field, Index(field,'&',-2)+1)
or else
subfield([Source field], '-', -2) as [Destination field]
Please try
date(date#(x,'YYYY-MM'),'M')