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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Robin99

    Date formula to first of next month

    Damon & LB, Both solutions worked perfectly - Thanks to you both for the fast response! - Robin
  2. Robin99

    Date formula to first of next month

    Hi, CRv10 on Enterprise Data source: Encore/Impact 6.0 (ODBC) Field Name: {ARINVOICE.InvoiceDate} Field type: Date Background: I'm writing a "welcome letter" (form letter) to send to our customers who buy our warranty support services. The warranty start date is always the 1st day of the...
  3. Robin99

    CEv10 Business Users & Setting Report Parameters

    Thanks for the suggestion. Setting defaults to pull a report with no detail and displaying the user's specified parameters in the header is a good idea as a standard practice anyway. I'll make sure I start doing that on all reports. When you mentioned "Pink Slip" report, what did you mean?
  4. Robin99

    CEv10 Business Users & Setting Report Parameters

    CRv10 on CEv10 Data source: Encore/Impact 6.0 (ODBC) When business users run (schedule) reports on CE, they are not presented with a "Parameters" dialog box asking them to make their choices (date range, invoice number, etc.). I know the "Customize Your Options" pick list is there and the...
  5. Robin99

    Splitting a String for two fields

    Thanks to you both for the fast response. (I've been trying to work this out since 7:30 this morning) Your suggestions worked perfectly. My report is beautiful; it's on time and my boss thinks I'm a Rock Star! Thanks again and have a happy holiday! - Robin
  6. Robin99

    Splitting a String for two fields

    Hello, Using CRv10 Data Source: Excel Data Type: String I'm trying to show the date of manufacture & the manufacturer of our product using a formula based on their 10 digit serial numbers. Not sure how to get what I'm after though... Serial Example: 0436040002 the 1st & 2nd digits represent...
  7. Robin99

    Number to Time Conversion

    CR Version 7 DB = Encore/Impact/Syspro 5.1 ODBC Hello, I'm working with a Transaction Time field that returns time values like: 8311576 and 10125494. CR Field Type is: Number How can I convert the above values into an HH:MM format? Thanks as always for the help. Robin
  8. Robin99

    Number to Date Conversion

    Hi Brian, I was in fact the cdate! I went to CR Tech Support site again and downloaded a whitepaper on date/time formulas. It says that the cdate function is not available until version 8. I did as you requested and replaced "cdate" with "date" in SV's formula... VOILA! It worked. Thanks...
  9. Robin99

    Number to Date Conversion

    EUREKA! I FOUND IT! I went to CR tech support site and found the following: NumberVar YYYY; NumberVar MM; NumberVar DD; YYYY := Truncate({SORCHANGES.TrnDate} / 10000); If Truncate(({SORCHANGES.TrnDate} - (YYYY * 10000)) / 100) > 0 and Truncate(({SORCHANGES.TrnDate} - (YYYY * 10000)) /...
  10. Robin99

    Number to Date Conversion

    Hi, No, I get the same error message on: cdate(val(left(totext(19700101,0,""),4)),val(mid(totext(19700101,0,""),5,2)),val(mid(totext(19700101,0,""),7,2))) Could it possibly be the "cdate"? My cursor gets placed in front of it every time I get the "The remaining text does not appear to be part...
  11. Robin99

    Number to Date Conversion

    Of course I used MY table names, I just didn't paste correctly in my reply. (shoot!) Here's the real formula... cdate(val(left(totext({SORADDITIONS.TrnDate},0,""),4)), val(mid(totext({SORADDITIONS.TrnDate},0,""),5,2)), val(mid(totext({SORADDITIONS.TrnDate},0,""),7,2))) Sorry for the error...
  12. Robin99

    Number to Date Conversion

    Hi Dave, I tried your formula too, but also get an error message. "The ) is missing..." When I put the ) where my cursor lands, I get: "The remaining text does not appear to be part of the formula..." Sorry to be a pain in the posterior - I sure appreciate the help. LMK if I can provide any...
  13. Robin99

    Number to Date Conversion

    Hi SV, I'm in the Formula Editor. My formula looks like this: cdate(val(left(totext({table.numberfield},0,""),4)),val(mid(totext({table.numberfield},0,""),5,2)),val(mid(totext({table.numberfield},0,""),7,2))) When I click the "check for errors" button, I get this error message:"The remaining...
  14. Robin99

    Number to Date Conversion

    Hi Vampire, I right clicked the field, clicked "browse data" and the Type is in fact: "number" I tried your subsequent formula just in case and got the same error message as before... - RRR
  15. Robin99

    Number to Date Conversion

    Hi Vampire, Thanks. I tried the formula (replaced "19700101" with my fieldname), but I'm getting the following error msg: "The remaining text does not appear to be part of the formula..." And my cursor is placed at the very beginning, right before "cdate". Any ideas?
  16. Robin99

    Number to Date Conversion

    Hi, Using CR7 with Impact/Encore 5.1 ODBC Today I'm writing a bookings report. When I pull a "transaction date" field from our DB, it produces date values in the following format: 20011012 20030707 20040205 However, my desired output is mm/dd/yy. The data type for this field in CR is...
  17. Robin99

    calculating line item discounts for extended line price

    Hi K, Thanks for taking the time to respond to my question - the first formula you provided worked like a charm! - RRR
  18. Robin99

    calculating line item discounts for extended line price

    Hi, I'm writing an invoice report (Crystal 7.0) and I'm running into problems calculating the line item discount and arriving at the correct extended amount. My discount field returns a value of "60.00" for a 60% discount - and I think that's one of my problems. Formula Example: if...
  19. Robin99

    A good question ! (Groupwise)

    I want to send an email to Groupwise user. But I want to do that when I click a button in my application (Java). After that I would like to be able to know if the email has been read by destination. Is there any Groupwise API to do that ? Thanks Robin robin.tremblay@cognicase.ca

Part and Inventory Search

Back
Top