Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have date field like this TotalCJan2015,TotalCFeb2015,TotalCMar2015,.....;
how can I get jan2015,Feb2015,Mar2015...;
Thanks Advanced
=Replace( yourfield,'TotalC','')
try like this in script:
right(Field,7) as Field
hope this helps
date#(right([Your_Field_Name],7),'MMMYYYY')
=Replace( yourfield,'TotalC','')
String functions:
Right(yourText, 7)
Replace(yourText, 'TotalC', '' )