Search results for query: *

Thanks lbass, that got it. Also thanks synapsevampire.

Sorry, I meant to say, the age of the very frist record in the report is always empty. The rest of the records the frist age is always zero. 11054 WAPPR 3/15/04 11054 APPR 3/15/04 392.00 11054 COMP 4/11/05 21.00 11054 CLOSE 5/2/05 0.00 19752 WAPPR 10/5/04 0.00 19752 APPR 10/10/04 190.00...

Wait, I'm getting closer. I used this forumla and now I get what I want except on the very frist record. That age is always empty. if {wostatus.wonum}= previous({wostatus.wonum}) and {wostatus.wonum}= next({wostatus.wonum}) then datediff("d",{wostatus.changedate},next({wostatus.changedate})) else 0

Thanks synapsevampire, thats pretty close. It gives me the age, but it places it on the wrong row, heres an example: WAPPR 2004 1:39:00PM 0.00 APPR 2004 1:02:00PM 5.00 COMP 2005 10:04:00AM 190.00...

Cyrstal v8, MS Sql 2000 db. I'm trying to get the age, in days, of Workorder statuses. The statuses are stored in one table(wostatus) with a change date. Here's an example: wonum status changedate --------------------------------- 2932 WAPPR 2005-05-01 08:55:00.000 2932...

Using the BCP utility I can create CSV files with no problem. But I would like the ability to update an existing CSV file instead of creating a new one. Is this possible?

Works great, thanks!

Crystal 8 Sql 2000 I have a report of Purchase Orders that is grouped by the order date based on the year. This works great but I want to group on the fiscal year instead. The fiscal year is 12/1 to 11/30. What kind of formula could I use to do this? I dont have or want any kind of data...

I'm using a batch file to delete files based on the file name. The file name is formatted like this: "log07-14-2004.txt" I need a way to take the current date in DOS and minus it by one day. Here's what i got so far: @echo on set currdate=%date% set mm=%currdate:~4,2% set dd=%currdate:~7,2% set...

Thanks, I guess I could live with that. I prefer that the user not have to enter the wildcard, any suggestions?

I have a record selection fromula thats giving me some trouble. {equipment.eqnum} like "*"&{?Eqcode}&"*" Its works with one input parameter but when i check "allow multiple values", i get this error: "This Array must be subscripted. For example: Array[i]." The cursors lands between & and...

Thanks Bonestein, that fixed it.

For some reason my Quick Launch Bar appears on the right end of the task bar. Is there a way to move it back to the left end next to the start button? I've already tried; rebooting,turning the bar off and back on, and dragging and dropping. Any other suggestions? Thanks Charles

The glaccounts will always be distinct. I think your query returned everthing but what i needed.

Checkai, I get codes with a length of 10, but they still have matching codes with 15. Donutman, you query gets me close enough. Your code also returns glaccounts that are 15 in length but have no corresponding code of 10. Does make sense? I.e, returns 110640400000000 which does not have a...

I'm trying to query a table to find certain Glaccount codes. The datalength of the code varies, the maximum length of the code is 15, but I only want to find the codes that have a datalength of 10. Here's the catch; Some of the codes have only 10 char, but there will be a code that matches the...

Here's there a simple way to calculate a specific time based on a time + a number of hours and minutes. I.E. dim timein as date = "7:55 am" dim hours as decimal = "8.05" dim answer as date answer = timein + hours answer = 3:58 pm I've tried Datediff but it doesnt give me what i need. Any...

Works great! Thanks!

I have some character strings that look like this: PM-FV-CARS-TRUCKS-5k PM-FV-CARS-TRUCKS-10k PM-FV-CARS-TRUCKS-100k I would like to get just the number out of the string. i tried using this: declare @jpnum varchar(25) set @jpnum = 'PM-FV-CARS-TRUCkS-100k' select...

Orginially I wanted to do a Select distinct records On the frist four and three characters based on datalength. Now I'm just using the formula in a formula field, grouping by the formula and hiding the detail section. Thanks for everybodys help.