473,326 Members | 2,095 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Extract 'days' from now till future fixed date

How would one extract the number of (days) from (today) and a (future fixed
date)- eg: February 12, 2003.

....where today will always be Date().

Thus:

02/12/04 - Date(now) = 27 days.

Can anyone help me here?

Thanks in advance
- Jason
Jul 19 '05 #1
3 1820
Using the DateDiff function is an option.
http://msdn.microsoft.com/library/en...ctDateDiff.asp

Download the documentation here.
http://www.microsoft.com/downloads/d...6-1C4099D7BBB9

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:Ox**************@TK2MSFTNGP10.phx.gbl...
How would one extract the number of (days) from (today) and a (future fixed date)- eg: February 12, 2003.

...where today will always be Date().

Thus:

02/12/04 - Date(now) = 27 days.

Can anyone help me here?

Thanks in advance
- Jason

Jul 19 '05 #2
Thanks!

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:#Z**************@TK2MSFTNGP10.phx.gbl...
Using the DateDiff function is an option.
http://msdn.microsoft.com/library/en...ctDateDiff.asp

Download the documentation here.
http://www.microsoft.com/downloads/d...C48-207D-4BE1-
8A76-1C4099D7BBB9
Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:Ox**************@TK2MSFTNGP10.phx.gbl...
How would one extract the number of (days) from (today) and a (future

fixed
date)- eg: February 12, 2003.

...where today will always be Date().

Thus:

02/12/04 - Date(now) = 27 days.

Can anyone help me here?

Thanks in advance
- Jason


Jul 19 '05 #3
Guys, this also works for me:

strDateTime = Now() strFutureDay = #02/12# %> Display The Result:

See:
http://www.jamesrking.com/left_brain...e_and_time.asp
"jason" <ja***@catamaranco.com> wrote in message
news:Ox**************@TK2MSFTNGP10.phx.gbl...
How would one extract the number of (days) from (today) and a (future fixed date)- eg: February 12, 2003.

...where today will always be Date().

Thus:

02/12/04 - Date(now) = 27 days.

Can anyone help me here?

Thanks in advance
- Jason

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: .:DeVa:. \( \) | last post by:
Need function thath will list all days till today in current month... TNX..
12
by: Anthony Robinson | last post by:
Is anyone aware of a function (system or user defined) that will calculate business days? For instance: I have a column in as table called DATE. I want to be able to add five business days to that...
5
by: BlackFireNova | last post by:
I need to write a report in which one part shows a count of how many total records fall within the working days (Monday - Friday) inside of a (prompted) given date range, in a particular...
8
by: MLH | last post by:
Anybody's solution would be appreciated. Pls, do not pause to write anything for this. I'm not looking for that kind of a handout. I have an idea about how to do it, but I wanted to see if anyone...
8
by: Simon Mansfield | last post by:
The code has the same end result as the last one.. It must tell the user how many days it has been since their birthday. Now it does give a result but its normally off by a bit.. I have figured out...
5
by: Juan | last post by:
Hi everyone, is there a function that calculates the exact amount of Years, Months, and Days between two days? TimeDiff is not good enough, since it calculates, for example: Date 1: Dec....
0
by: napolpie | last post by:
DISCUSSION IN USER nappie writes: Hello, I'm Peter and I'm new in python codying and I'm using parsying to extract data from one meteo Arpege file. This file is long file and it's composed by...
3
by: Cyprus106 | last post by:
I can't seem to get a reliable function that grabs the actual date 30 days in the future. Adding +30 to the date() function doesn't seem to compensate for if the next month has less than the +30...
0
by: geraldjr30 | last post by:
hi, i have the following: <?php echo"test"; //The function returns the no. of business days between two dates and it skips the holidays function...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.