jchewsmith
Technical User
How do you base a formula on a parameter date less 1 year?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Formula 1
- Thread starter jchewsmith
- Start date
- Status
-
1
- #2
- Thread starter
- #3
jchewsmith
Technical User
I am trying to create a prior year formula to take a field year (2008.00) and reduce it by one year.
then use the new formula to compare to the field year to pull last years info.
then use the new formula to compare to the field year to pull last years info.
I'm not following. Are you saying now that you are NOT using a parameter for the year? Do you actually have a field that returns a number for the year?
I think you should say what you are trying to do overall, instead of assuming that a certain approach is the best one.
If you have a field {table.year}, you should be comparing it to the current year, to a parameter, or to a hard value, not to itself (even if altered in a formula).
-LB
I think you should say what you are trying to do overall, instead of assuming that a certain approach is the best one.
If you have a field {table.year}, you should be comparing it to the current year, to a parameter, or to a hard value, not to itself (even if altered in a formula).
-LB
- Status
Similar threads
- Locked
- Question