We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This very simple solution applies to a narrow cross-section of the "needs to close" variety.
In this case, the full message in Event Viewer was in applog, Event ID 1000:
Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring.
SCOM monitors:
Windows or UNIX/LinuxNetwo…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels.
Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 3 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.