formatting dates (97)

Topic

New Reply

formatting dates
my report groups by month, but when I place

Reply | Quote

Replies

In the group header, I placed: =Format$([FieldName],”mmmm”) as the Control Source. I see all the months as “January” through “December”.
What do you have as the Control Source statement? Is it in the Group Header section?

Reply | Quote

arage,

Make sure that the field you’re formatting as “mmmm” is a date field. If the field has “1” for January, “2” for February, etc. you’ll have problems (but in this case you could use the choose(n, string1, string2, …) function instead of the format() function).

Reply | Quote

thanks I did eventually go with the choose( ) to help out, I realized the month I was using was actually an expression based upon a date field so the field itself could not be considered of type date.

Reply | Quote