• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

Fox 9 and Date Fields in Report Writer

I am creating a report which requires a year to be represented as 68 instead if 1968 which is what I get when I do    year(dateserve.appeals)   in the expression section of the report writer. The data is drawn from a date field in a table which is connected to the report.

Day   day(dateserve.appeals) works find delivering  up to two intergers as does
month(dateserve.appeals).

What I need is the year to report as the last two digits of the year 68 for 1968.

Anyone know how to get report to take a date field from a table and do this for year.

Happy Holidays and Happy New Year

Dan
0
Malibucompany
Asked:
Malibucompany
  • 2
3 Solutions
 
CaptainCyrilFounder, Software Engineer, Data ScientistCommented:
When calling the report SET CENTURY OFF

SET CENTURY OFF
REPORT FORM myreport.frx
SET CENTURY ON
0
 
peterhuppCommented:
RIGHT(STR(year(dateserve.appeals)),2)

There might be fancier ways but the above will work just fine.
0
 
CaptainCyrilFounder, Software Engineer, Data ScientistCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now