Solved

Fox 9 and Date Fields in Report Writer

Posted on 2012-12-24
3
595 Views
Last Modified: 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
0
Comment
Question by:Malibucompany
[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
3 Comments
 
LVL 27

Assisted Solution

by:CaptainCyril
CaptainCyril earned 334 total points
ID: 38718801
When calling the report SET CENTURY OFF

SET CENTURY OFF
REPORT FORM myreport.frx
SET CENTURY ON
0
 
LVL 3

Assisted Solution

by:peterhupp
peterhupp earned 166 total points
ID: 38718805
RIGHT(STR(year(dateserve.appeals)),2)

There might be fancier ways but the above will work just fine.
0
 
LVL 27

Accepted Solution

by:
CaptainCyril earned 334 total points
ID: 38718806
0

Featured Post

Industry Leaders: We Want Your Opinion!

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!

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

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.

Join & Ask a Question