Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Date Time to Date with MMM-YY Post Reply Post New Topic
Author Message
Alb2tead
Newbie
Newbie
Avatar

Joined: 06 Nov 2012
Location: United States
Online Status: Offline
Posts: 13
Quote Alb2tead Replybullet Topic: Date Time to Date with MMM-YY
    Posted: 28 Aug 2013 at 6:34am
I have figured out how to extract the month and year using the totext, but I need to take the MMM-YY out of a MMDDYYYY and leave it in date format.
 
When I format the date and export to excel it still reads the MMDDYYYY when I need it to read MMM-YY.  Is this even possible.
 
Please Help Cry
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 28 Aug 2013 at 11:32am
try a formula like
left(monthname(month(left(table.field_name,2))),3) + "-"+ right(table.field_name,2)
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.047 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.