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?
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 McSwainBusiness 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
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi SauerbreiSent: Tuesday, 25 January 2011 13:39To: Ken McSwainSubject: [Tessitura Technical Forum] Infomaker Date format
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=====
Hmmmm.... that didn't work very well, did it?
What I meant to say was - a format string like
mmmm dd, yyyy
(No quotes), entered directly in to the Format box on the Format tab, as opposed to the named formats like [Short Date] which IM puts in there by default, generates a display date like "November 10, 2011".
The strings are similar to, but of course not identical to, the ones that Microsoft uses in VB-based stuff.
Ken
Success!
My problem was that I had previously tried to use conditional formatting on it (clicking the formula button next to the Format field). Hadn't cleared it out. Once I did everything worked swimmingly.
Thanks Ken!