Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formatting dates (97)

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

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formatting dates (97)

    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?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formatting dates (97)

    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).

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formatting dates (97)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •