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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parmeter formula for looking up date range in table
Thanks so much for your information. The database is iseries db2. The date field is just a number field in yyyymmdd format. I believe you would consider this a table lookup for the year, then lookup the currdate within the ranges in the file. The table has the fields year, date range. I want...- SUEF
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Parmeter formula for looking up date range in table
I have an accounting period table that has the year and then a date range for each period. The format of the table is yyyymmdd for the dates. I would like to query the table and take the currdate find the current year based on the currdate then pull in the date range the currdate is in for my...- SUEF
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 2 Data Access
