Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
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
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
Asked:
2
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 Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
SET CENTURY OFF
REPORT FORM myreport.frx
SET CENTURY ON