Fox 9 and Date Fields in Report Writer

Malibucompany
Malibucompany used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
CaptainCyrilFounder, Software Engineer, Data Scientist
Commented:
When calling the report SET CENTURY OFF

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

There might be fancier ways but the above will work just fine.
Founder, Software Engineer, Data Scientist
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial