Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula to Show Month Post Reply Post New Topic
Author Message
dkalsow
Groupie
Groupie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 65
Quote dkalsow Replybullet Topic: Formula to Show Month
     Posted: 10 Mar 2011 at 6:12am

Good Morning,

Does anyone know who to write a formula which will accept a value and from that value return the human readable month from the value passed?
 
 
Thanks :)
dkalsow
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet Posted: 10 Mar 2011 at 6:38am
Yes. You can use the MonthName(x) function that takes in a number x and returns the name of the month (ie: if x = 10, it will return "October")

The function also accepts a boolean value along with the number, so if you want to show Oct instead you can just write

MonthName(10, True)
IP IP Logged
dkalsow
Groupie
Groupie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 65
Quote dkalsow Replybullet Posted: 10 Mar 2011 at 6:54am
Thanks, thats great! How do I tell a formula to expect a value to be passed to it and then use it?
Thanks :)
dkalsow
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.