Get Date Field for text

[rish_sai]

Hi All,

I have date field like this TotalCJan2015,TotalCFeb2015,TotalCMar2015,.....;

how can I get jan2015,Feb2015,Mar2015...;

Thanks Advanced

[Frank_Hartmann]

try like this in script:

right(Field,7) as Field

hope this helps

[Nicole-Smith]

date#(right([Your_Field_Name],7),'MMMYYYY')

[robert_mika · Accepted solution]

=Replace( yourfield,'TotalC','')

[Anonymous]

String functions:

Right(yourText, 7)

Replace(yourText, 'TotalC', '' )