Date Time to Date with MMM-YY
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19962
Printed Date: 02 May 2024 at 8:38pm
Topic: Date Time to Date with MMM-YY
Posted By: Alb2tead
Subject: Date Time to Date with MMM-YY
Date 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
 |
Replies:
Posted By: kostya1122
Date 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) |