Link to home
Start Free TrialLog in
Avatar of TomBalla
TomBallaFlag for United States of America

asked on

Crystal reports month formula

I need a formula that looks at a date like 03-13-2012 and tells me what month it is.  

If datefield starts with 03 then March, kind of formula.
ASKER CERTIFIED SOLUTION
Avatar of Haver Ramirez
Haver Ramirez

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

Is it a date field or a string?

If it is a date then use the above as
   ToText({YourDateFIeld}, 'MMM')

If it is a string then

    MonthName(Val(Left({yourDateString},2)))

or

    MonthName(Val(Left({yourDateString},2)),True)

mlmcc