forum.vdsworld.com

flypaper · Contributor Joined: 19 Oct 2001 Posts: 104

Im using VDS4 if this makes a difference.

This program I'm creating inserts a task into the Windows task scheduler on the next day. So I need to add a day to the current date. I know with @datetime() I can get a floating point number, but how can I add a number to it and get a date back out?

I realize that I could probably use datetime.dll, but if its simple enough to do, I'd like to avoid that.

Thanks for your awesome help as usual guys.

Serge · Posted: Mon Mar 21, 2005 2:41 pm Post subject:

as i understand it, when vds returns a date as a decimal then the integer part deals with the date while the decimal deals with the time

eg. 2345.6789 would have 2345 dealing with the date, so adding 1 to it will give you the next day's date, and .6789 deals with the time

serge

flypaper · Contributor Joined: 19 Oct 2001 Posts: 104

Yes, but how to I get that number back into a date format, like 3/21/05?

Serge · Posted: Mon Mar 21, 2005 2:49 pm Post subject:

@datetime(dd/mm/yy,234.5678) should do it

serge

flypaper · Contributor Joined: 19 Oct 2001 Posts: 104

Similar problem...

I need to add 2 minutes to the time. Is there a breakdown of what floating point number is the minutes in @datetime()?

BTW, thanks TONS for your help.

Serge · Posted: Mon Mar 21, 2005 3:40 pm Post subject:

yes there is, someone posted a while back what the decimal number is for a minute, a second but i don't remember when and where

do a search at the forum and see if you can find it

serge

jules · Posted: Mon Mar 21, 2005 4:30 pm Post subject:

I wonder about you guys sometimes. Wink

A minute is 1 / 24 / 60. You can use the Windows calculator to work it out. Since I can never remember the value I do it all the time.

flypaper · Contributor Joined: 19 Oct 2001 Posts: 104

Hooligan · Posted: Mon Mar 21, 2005 5:37 pm Post subject:

Flypaper,

1 day = 1.0 in VDS time/date format.

There are 24 hours in a day, so 1 hour = 1 divided by 24.

There are 1440 minutes in a day, or 60 minutes in an hour,
so 1 minute = 1 divided 1440, or 1 divided by 24 divided by 60 (Jules equation).

There are 82400 seconds in a day, so 1 second = 1 divided by 82400,
or 1 divided by 24 divided by 60 divided by 60.

I hope this helps...

Hooligan

flypaper · Contributor Joined: 19 Oct 2001 Posts: 104

That took me a few minutes to wrap my small brain around, but i understand whats going on now. thanks guys!

Serge · Posted: Mon Mar 21, 2005 11:11 pm Post subject:

Serge · Posted: Mon Mar 21, 2005 11:18 pm Post subject:

Mac · Posted: Mon Mar 21, 2005 11:45 pm Post subject:

No offense - but if folks would search the forums, many
questions have been already answered. Wink

This link was posted about @datetime() info over two
years ago:
http://www.vdsworld.com/forum/viewtopic.php?t=919

Cheers, Mac Smile