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®
View Solutions Only
CaptainCyrilFounder, Software Engineer, Data Scientist
Commented:
When calling the report SET CENTURY OFF

SET CENTURY OFF
REPORT FORM myreport.frx
SET CENTURY ON
peterhupp
Commented:
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