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
MalibucompanyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
CaptainCyrilConnect With a Mentor Founder, Software Engineer, Data ScientistCommented:
0
 
CaptainCyrilConnect With a Mentor Founder, Software Engineer, Data ScientistCommented:
When calling the report SET CENTURY OFF

SET CENTURY OFF
REPORT FORM myreport.frx
SET CENTURY ON
0
 
peterhuppConnect With a Mentor Commented:
RIGHT(STR(year(dateserve.appeals)),2)

There might be fancier ways but the above will work just fine.
0
All Courses

From novice to tech pro — start learning today.