Convert month from (03/20/2003) into March

[ricksmith2005]

Hi,

I have a report that pulls data of birth in 03/20/2003 format every week, now I want to convert this month 03 into March. This will be the Header of the report. Please let me know how I can achieve this in impromptu.

Thx
Rick

 

[semby]

In Impromptu you should just have to do a:
left(monthname(date_value), 3)

where left is the left function, monthname is the monthname function, date_value is your date field, and 3 is the numeral passed as part of the left arguement.

That worked for me against a SQL Server db.

-Charles