functions

[prabhas277]

Hi,

left('7/8/2015',Index('7/8/2015','/',-1)-1) this is my function that output is 7/8 .But my requirement is i want only 8.

how we can achive it?

[MK_QSL]

=TextBetween('7/8/2015','/','/')

[prabhas277]

HI sorry the exact question is

left('7/8/2015',Index('7/8/2015','/',2)-1) this is my function that output is 7/8 .But my requirement is i want only 8.

how we can achive it?

[alexandros17]

=Mid('7/8/2015',Index('7/8/2015','/',-1)-1,1) 

[prabhas277]

hi thanks to sharp reply

by using left and index function how can get it?

[veidlburkhard]

Hi prabhas

You can use the function Textbetween or Subfield:

In your case Textbetween(Date, '/', '/') = 8

or

Subfield(Date, '/', 2) = 8

Regards

Burkhard

[prabhas277]

hi

by using left and index function how we can get it?

[brian_booden]

Hi,

How about if it is a string:

Mid('7/8/2015', Index('7/8/2015', 8), 1)

or if the field is a date:

Num(Month(Date('7/8/2015')))

Regards,

Brian

[florentina_doga]

or

subfield('7/8/2015','/',1)

[alexandros17]

I think it is not possible because left returns the left part of a string strarting from a position ...