Fox 9 and Date Fields in Report Writer
Posted on 2012-12-24
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
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