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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by SkipWhitten
-
Date Parameter doesn't return data from 2012. Stops at 12/31/2011
Crystal Report Professional v10.0 (32-bit) - Report Definition 1.0 File Information Report File: Version: 10.2 2.0 Record Sort Fields A - {tsoSalesOrder.Expiration} A - {tsoSalesOrder.UserFld1} 3.0 Group Sort Fields 4.0 Formulas 4.1 Record Selection Formula not...- SkipWhitten
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Date Parameter doesn't return data from 2012. Stops at 12/31/2011
The parameter is string. Here is the formula to switch it around. if length ({tsoSalesOrder.userFld1}) = 10 then {tsoSalesOrder.userFld1}[6 to 7]+ "/" + {tsoSalesOrder.userFld1}[9 to 10] + "/" + {tsoSalesOrder.userFld1}[3 to 4] else {tsoSalesOrder.userFld1} The date displays like this after...- SkipWhitten
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Date Parameter doesn't return data from 2012. Stops at 12/31/2011
Hi, I have a report that includes a date parameter (equal to ot greater than) that won't return data that has a date in next year (2012). I did not create this but the end users tell me that this happens every December and that the previous consultant would tweak it and they'ld be good for the...- SkipWhitten
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 4 Other topics
-
How to import new inventory items into MAS200
A inventory import is pretty straightforward. There are required fields that are color coded in VI. Have your reseller create a template for you. You'll pay for it once, and use it whenever you want. It will need to be rewritten when you move to v4.4. Have your reseller include that upgrade in...- SkipWhitten
- Post #3
- Forum: Sage 100 ERP (fka Mas90/Mas200)
