[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Running Total Reset on Year but only have xx/xx/xxxx date field available

Posted on 2005-05-11
Medium Priority
319 Views
I am creating a report and I need to reset on a YYYY (4 digit year)  Now the only option I have for date field is a xx/xx/xxxx date field.  How can I create  statement that I can sort by use of a formula where I can put the date field in and it will strip off the 4 digit year?  Basically I am copying a report we use to do something else and in that report there was  field that has a YYYY four digit year and in the new datasets the only thing I have is a full date set.  I need to be able to reset on change of year.  PLEASE HELP!
0
Question by:mfehrmann
• 3
• 2

LVL 9

Expert Comment

ID: 13981186
- Set one of them to correct height
- Select all fields to be adjusted
- Rightclick the correct field -> size -> same height

Selecting fields can be done by clicking them all, or just by holding the left button down and draw a rectangle

hth,

Outin
0

LVL 9

Expert Comment

ID: 13981190
Sorry, wrong topic. Be back soon ;-)

--
Outin
0

LVL 9

Accepted Solution

Outin earned 1000 total points
ID: 13981205
Create a formula like this:

Year({DATEFIELD})

hth,

Outin
0

LVL 101

Assisted Solution

mlmcc earned 1000 total points
ID: 13983036
That should work.  You can then group on the year or reset on change of the year.

mlmcc
0

LVL 5

Author Comment

ID: 13987167
I ended up creating a view of the oracle table that I was working with and then created a YYYY field and then did my sorting and grouping off of that.

Thanks for everyones input though.  I will probably be back with more questions in the future seeing as I suddenly have all these reports that people want me to do.
0

LVL 101

Expert Comment

ID: 13991796

mlmcc
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
###### Suggested Courses
Course of the Month17 days, 21 hours left to enroll