• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 46 views
  • Users 0 members are here
Related

Infomaker Date format

Levi Sauerbrei
$organization

I've seen something close to this elsewhere in the forums, but not exactly what I need.  I'm trying to format a date field on a report thus:

January 24, 2011

Using month(today())+" "day(today())+", "+year(today()) is almost the right answer, but instead of the month name I get the integer.  Is there a function to display the month name?  Or do I need to build a wildly long IF statement?

Parents
  • Former Member
    Former Member $organization

    Hi Levi

    If you just want to Display in a different format, you can use microsoft-esque format strings in the Format tab of the control – like this:

     

     

    Screen clipping taken: 25/01/2011, 13:53

     

     

     

     

    Ken McSwain
    Business Solutions Manager

    T 02 9250 7876  F 02 9251 7821  M 0418 659 360

     

    Sydney Opera House Bennelong Point

    GPO Box 4274 Sydney NSW 2001 AUSTRALIA

     

    SOH_LOGO.gif

    FACEBOOK.gifTWITTER.gifYOUTUBE.gifBLOG.gif

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Tuesday, 25 January 2011 13:39
    To: Ken McSwain
    Subject: [Tessitura Technical Forum] Infomaker Date format

     

    I've seen something close to this elsewhere in the forums, but not exactly what I need.  I'm trying to format a date field on a report thus:

    January 24, 2011

    Using month(today())+" "day(today())+", "+year(today()) is almost the right answer, but instead of the month name I get the integer.  Is there a function to display the month name?  Or do I need to build a wildly long IF statement?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
  • $organization in reply to Former Member

    Ken,

    Thanks for the pointer! Unfortunately, the screenshot didn't come through.  But I'll start checking out the "Microsoft Method" :)

  • $organization in reply to Levi Sauerbrei

    Hmmm...

    Using 

    MMMM dd, YYYY

    Shows a correct sample format in Infomaker, but when I run the report in Tessitura it comes out 1/24/2011 21:11:59.

    Am I missing a checkbox on the field somewhere?

Reply Children
No Data