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...
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
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...
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?
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"?
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.
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
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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.