Loading last digit in a string

[#1]

Hi how would I load '2015-08' so that only '8' is displayed ?

Thanks

[sunny_talwar]

Try this:

Right(FieldName, 1) as Digit

[avinashelite]

right(our_field_name,1)

[#4]

Sorry should have been far clearer as it's not always the last digit.

Basically I have the following :

2014-09

2014-10

2014-11

What I want is to always be left with the month so my results would show as such :

9

10

11

[manojkulkarni]

you can use

right(FieldName,2) or subfield(FieldName,'-',2)

[maxgro]

num(month(date#(yourfield, 'YYYY-MM')))

[sunny_talwar]

Try this:

Num(Month(Date#(DateFieldName, 'YYYY-MM'))) as Month_Num

[Peter_Cammaert]

or if you just want the month number and not the underlying date value:

num(right(fieldname,2),'#0')

[Edit] took out the whitespace to make it even smaller. That's about the only advantage: fewer characters to type

[amayuresh]

Try this

=MID(FieldName,index(FieldName,'-')+1) as Month_Num

[jagan]

Hi,

Try

Num(Right(FieldName, 2))

Hope this helps you.

Regards,

jagan.