Wednesday, October 19, 2011

Formatting a Date in Crystal Report.

ToText(Month ({PriceIncreaseOverRide.PriceIncreaseEffectiveDateTo}),0)
+ "/" +
ToText (Day ({PriceIncreaseOverRide.PriceIncreaseEffectiveDateTo}),0)
+ "/" +
ToText(Year ({PriceIncreaseOverRide.PriceIncreaseEffectiveDateTo}),"####")
or
ToText({PriceIncreaseOverRide.PriceIncreaseEffectiveDateTo},"MMM-dd-yyyy")
Posted by siva's blog at 5:36 PM
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)