Recent content by Robin99

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

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...

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?

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...

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

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...

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

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...

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)) /...

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...

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...

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...

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...

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

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?