473,320 Members | 1,969 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,320 software developers and data experts.

Date difference

Hi to all !
I have 2 fields in a MySQL database. The fields contains calendaristic data.
I want to generate a HTML report and make difference between theose date
fields.

Is there a function in ASP to accomplish this task (like :
"=dateDiff(date1,date2)" where date1 and date2 are calendaristic dates)?

Thanks for your help.

--
Alexandru TUDOSE
Network Administrator
Quality Responsable
Takosan Automotiv Srl
Tel / Fax : 0040 248 651548
Mobil : 0040 740 147 346
Oct 7 '05 #1
2 7206
"Alexandru TUDOSE" <ad***********@takosan.ro> wrote in message
news:OT**************@TK2MSFTNGP09.phx.gbl...
Hi to all !
I have 2 fields in a MySQL database. The fields contains calendaristic data. I want to generate a HTML report and make difference between theose date
fields.

Is there a function in ASP to accomplish this task (like :
"=dateDiff(date1,date2)" where date1 and date2 are calendaristic dates)?

Thanks for your help.

--
Alexandru TUDOSE
Network Administrator
Quality Responsable
Takosan Automotiv Srl
Tel / Fax : 0040 248 651548
Mobil : 0040 740 147 346


"calendaristic"?

You're close. In vbscript:
DateDiff("d",date1,date2)
gives the difference in days.

Here's the full list:
"yyyy" = Year
"q" = Quarter
"m" = Month
"y" = Day of year
"d" = Day
"w" = Weekday
"ww" = Week of year
"h" = Hour
"n" = Minute
"s" = Second
Oct 7 '05 #2
Thanks a lot.
I'm sorry for my bad English.
I was thnking that the word "calendar" has the same meaning like in my own
language.

Thanks anyway.
"Alexandru TUDOSE" <ad***********@takosan.ro> wrote in message
news:OT**************@TK2MSFTNGP09.phx.gbl...
Hi to all !
I have 2 fields in a MySQL database. The fields contains calendaristic data. I want to generate a HTML report and make difference between theose date
fields.

Is there a function in ASP to accomplish this task (like :
"=dateDiff(date1,date2)" where date1 and date2 are calendaristic dates)?

Thanks for your help.

--
Alexandru TUDOSE
Network Administrator
Quality Responsable
Takosan Automotiv Srl
Tel / Fax : 0040 248 651548
Mobil : 0040 740 147 346

Oct 10 '05 #3

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

Similar topics

4
by: Richard Hollenbeck | last post by:
I'm trying to write some code that will convert any of the most popular standard date formats twice in to something like "dd Mmm yyyy" (i.e. 08 Jan 1908) and compare the first with the second and...
5
by: tamilan71 | last post by:
Hello All I have table with following fields: GroupId VisitDate 1 10/19/1993 1 11/24/1998 2 10/18/1993 2 10/29/1998 3 ...
7
by: Edward Mitchell | last post by:
I have a number of DateTimePicker controls, some set to dates, some set to a format of Time. The controls are all embedded in dialogs. I created the controls by dragging the DateTime picker from...
16
by: Atley | last post by:
I am trying to get a overall difference on two dates, I can get the difference in Years, Months, Weeks, Days, Hours, Minutes, Seconds, no problems... What I cannot seem to figure out is how to...
6
by: Scott | last post by:
I have a start date and an end date in my project that is defaulted to the current date at run-time using the following code... Date1.Value = Now() Date2.Value = Now() I then have some code...
13
by: priyasmita_guha | last post by:
Here is a program- /* PROGRAM: To find the difference between two dates */ #include<dos.h> #include<stdio.h> #include<conio.h> #include<process.h> void valid_date(int,int,int); int...
4
by: jamesyreid | last post by:
Hi, I'm really sorry to post this as I know it must have been asked countless times before, but I can't find an answer anywhere. Does anyone have a snippet of JavaScript code I could borrow...
3
by: bbawa1 | last post by:
Hi, I have a table which has a field ItemsReceived of type datetime. I have a grid view which has two columns. In first column i have to show the data from field ItemsReceived and in second...
7
by: rdawadiuk | last post by:
hi, I would like to calculate the date difference between two dates using field names which I have in my table. The field name is " Account opened on" for eg If the "Account open on" is Jan 5,...
6
by: krishnakant Mane | last post by:
hello, I am strangely confused with a date calculation problem. the point is that I want to calculate difference in two dates in days. there are two aspects to this problem. firstly, I can't get...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
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...
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
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
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.