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

    datediff betweens rows in a table

    Thanks lbass, that got it. Also thanks synapsevampire.
  2. dfwcharles

    datediff betweens rows in a table

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

    datediff betweens rows in a table

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

    datediff betweens rows in a table

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

    datediff betweens rows in a table

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

    Is it possible to update an existing CSV file with BCP?

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

    Group on Fiscal year

    Works great, thanks!
  8. dfwcharles

    Group on Fiscal year

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

    Minus 1 day from current date in batch file?

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

    Array in record selection

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

    Array in record selection

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

    Relocating Quick Launch Bar?

    Thanks Bonestein, that fixed it.
  13. dfwcharles

    Relocating Quick Launch Bar?

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

    Query problem

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

    Query problem

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

    Query problem

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

    calculating time

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

    getting numbers out of a string

    Works great! Thanks!
  19. dfwcharles

    getting numbers out of a string

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

    formula error"The result of selection formula must be boolean"

    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.

Part and Inventory Search

Back
Top