Fast Reports forum > Get Month from Number

Fast Reports forum > Fast Reports Products > FastReport 4.0

phc

Oct 12 2011, 04:45 AM

I have a access database that I have an ADO connection with in delphi. I have a data field with the Month of the year eg 1..12 I want to display it on the report as JAN..DEC

I have tried to format it in the SQL statement but cannot get it to work.
If I use the (FORMAT( MONTH( aMonth),"mmm")) as StartingMonth it only ever returns JAN
I have tried the access MonthName function but does not work through ADO.

Is there a way to format the display in Fast Reports

phc

Oct 12 2011, 05:25 AM

Got it to work with the SQL

FORMAT( DATEADD( "m", [aMonth]-1, "1/1/2000"), "mmm")

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.