TBSupport
asked on
Crystal Reports Formula Adding 1 to a Year "String" Field
Hello:
Below is an excerpt from an "If, Then" statement that I'm using in a formula in Crystal Report XI.
I need to edit the end of this formula. Specifically, I need to mathematically add a "1" so that the phrase displays "Month of January 1, 2014". As it is, the formula displays "Month of January 1, 2013".
When I try to tell Crystal's Formula Editor to add "1" to the year, it tells me that a string is required or something along those lines.
What syntax do I use to tell Crystal to add "1" to a year? I'd rather not have to hard-code in the year.
Thanks!
TBSupport
If {IVC10100.COMMNTID} = "JAN" then "Month of January 1, 20"+mid({IVC10100.INVCNMBR },3,2)
Below is an excerpt from an "If, Then" statement that I'm using in a formula in Crystal Report XI.
I need to edit the end of this formula. Specifically, I need to mathematically add a "1" so that the phrase displays "Month of January 1, 2014". As it is, the formula displays "Month of January 1, 2013".
When I try to tell Crystal's Formula Editor to add "1" to the year, it tells me that a string is required or something along those lines.
What syntax do I use to tell Crystal to add "1" to a year? I'd rather not have to hard-code in the year.
Thanks!
TBSupport
If {IVC10100.COMMNTID} = "JAN" then "Month of January 1, 20"+mid({IVC10100.INVCNMBR
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be closed as follows:
Accepted answer: 250 points for mlmcc's comment #a39691693
Assisted answer: 250 points for James0628's comment #a39692104
for the following reason:
TBSupport,
I have reopened your question and started the process of closing it with a split amongst two or more Experts, as that outcome seems more equitable than your original disposition.
modus_operandi
EE Admin
Accepted answer: 250 points for mlmcc's comment #a39691693
Assisted answer: 250 points for James0628's comment #a39692104
for the following reason:
TBSupport,
I have reopened your question and started the process of closing it with a split amongst two or more Experts, as that outcome seems more equitable than your original disposition.
modus_operandi
EE Admin
ASKER
If you need to split the credit, that's fine, of course.
ASKER
Is there anything else that I need to do? I'm confused, as to why this is remaining in my "Open Questions" box.
The admin started a process to reclose the question, but it doesn't happen for a few days (to give people time to object, I guess). I imagine that you could just close the question yourself (but include mlmcc's post as part of the solution this time). Otherwise, the question should be closed today, or in the next day or two.
James
James
You can use the "Request Attention" link to ask to have the question re-opened, and then accept mlmcc's post as the solution, instead of mine.
James