need only month from date

[sbcsandhu]

what is the formula i would use in crystal xi , so i only grab the month
example

20071103

i would like to create a formula that say 11

 

[dgillz]

mid(totext({YourField},0,""),5,2)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[CoSpringsGuy]

month(date((picture("20071103","xxxx,xx,xx"))))

works too

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[Madawc]

Month({your.date})

THis also works for Year. To get the day for calculations, use DatePart, which gives lots of other values. For display, there are options like

ToText({Your.Date}, "yy-MM")

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10