TomBalla
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.
If datefield starts with 03 then March, kind of formula.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If it is a date then use the above as
ToText({YourDateFIeld}, 'MMM')
If it is a string then
MonthName(Val(Left({yourDa
or
MonthName(Val(Left({yourDa
mlmcc