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

    Passing Form input with frames

    Hi all, have two problems: First, I have a web page with frames--frame on the right (which I'll call frmINPUT) accepts user input for use later. I have the standard form=get method...Now, I DON'T want the frmINPUT to change to the parameter receiving page...in other words, I just want to pass...
  2. Sharkfin01

    datediff() vs Excel time discrepancy

    I tried a similar approach where I just used datediff() and converted my date into seconds since Jan 1, 1900. However, when I convert back to days (standard divide by 3600 then by 24) I'm "short" of the Excel day by 2 days. Thanks
  3. Sharkfin01

    datediff() vs Excel time discrepancy

    When I use datediff() to find the number of days between now and Jan, 1, 1900, I'm off by roughly 2 days (and of course, whatever fraction of a day)..is there anyway I can fix this? i.e. get the same number as Excel would give if I converted a cell with 10/10/2001 12:00:00 to a number with 5...
  4. Sharkfin01

    UNIX timestamp conversion

    Nevermind..I jsut threw the string into a variable and it works...losing my patience I guess :P
  5. Sharkfin01

    UNIX timestamp conversion

    This is odd...I just telneted to my work PC and entered this: a=datediff("s", "1/1/70", "10/10/2001 24:00:00") and i get the following error: Type mismatch: '[string: "10/11/2001 24:00:00"]' where'd I goof?
  6. Sharkfin01

    UNIX timestamp conversion

    Indeed it is..thanks very much for your help. This will most definitely come in handy tomorrow..
  7. Sharkfin01

    UNIX timestamp conversion

    ok, since I'm not at my work PC now, I'm going to ask a dunce question. If I were to enter 10/10/2001 12:00:00 into your "NOW", I would get the equivalent Excel "timestamp"?
  8. Sharkfin01

    UNIX timestamp conversion

    Thanks for the help: Now of course, I have a followup. Is there anyway to take a formatted date: yyyy-mm-dd hh:mm:ss into Excel's "timestamp"--which is the number of days since Jan 1, 1970.
  9. Sharkfin01

    UNIX timestamp conversion

    Hello, is there a function that can convert a UNIX timestamp (seconds since Jan 1, 1970) to format: mm/dd/yyyy hh:mm:ss? The format is flexible, but I do need to get it down to minute resolution. Too bad vbscript doesn't have a handy date() function like PHP...grrr
  10. Sharkfin01

    Use Excel on the Web

    Hello: I'm designing a web page which will pull data from MySQL, then plot the data in a xy plot (with time on x) using Excel, and display the chart on the web. All I want for the user to see is the chart--similar to designing a historic stock quote. Any ideas on how I can get this working...
  11. Sharkfin01

    net use with Vb

    Is there a way for Visual Basic to call up a command prompt and then execute the net use command?
  12. Sharkfin01

    WnetAddConnection API help

    Hi, I'm having difficulty with the above API. In order for me to map to another person's c: drive in NT, I have to connect as an admin account (which I have). Usually, I just right click on Network Neighborhood, type the path to the computer, and in "Connect as:" I enter my admin...
  13. Sharkfin01

    remote registry reading

    I've seen past threads about getting registry values from a remote machine. But, seems as if no1 has answered any of them...Any new ideas that I missed?

Part and Inventory Search

Back
Top