|
I have two dates .The difference between them is almost three months and 20 days.How should I programatically calculate the no of days in these start date and end date.Is there any inbuilt function to do it.Or I need to apply my logic to accomplish it.
currently i am using the following code
private sub abc()<br />
Dim startdate As New Date(2006, 1, 1)<br />
Dim enddate As New Date(2006, 3, 1)<br />
Dim str(1) As String<br />
Dim counter As Integer = 0<br />
While (True)<br />
str(counter) = startdate.Day & "-" & Format(startdate, "MMM") & "-" & startdate.Year<br />
counter += 1<br />
ReDim Preserve str(counter)<br />
startdate = startdate.AddDays(1)<br />
If (startdate = enddate) Then<br />
str(counter) = startdate.Day & "-" & MonthName(startdate.Month) & "-" & startdate.Year<br />
Exit While<br />
End If<br />
<br />
End While<br />
End Sub
|
|
|
|
|
I have this code from the net.
We can use this function to find the difference in date,month,year,time.
But it is in C#.
Please try to understand this and convert into VB.NET code.
public enum DateInterval
{
Second, Minute, Hour, Day, Week, Month, Quarter, Year
}
public static long DateDiff(DateInterval Interval, System.DateTime StartDate,
System.DateTime EndDate )
{
long lngDateDiffValue = 0;
System.TimeSpan TS = new System.TimeSpan(EndDate.Ticks - StartDate.Ticks);
switch (Interval)
{
case DateInterval.Day:
lngDateDiffValue = (long) TS.Days;
break;
case DateInterval.Hour:
lngDateDiffValue = (long)TS.TotalHours;
break;
case DateInterval.Minute:
lngDateDiffValue = (long) TS.TotalMinutes;
break;
case DateInterval.Month:
lngDateDiffValue = (long)( TS.Days / 30);
break;
case DateInterval.Quarter:
lngDateDiffValue = (long)( (TS.Days / 30) / 3 );
break;
case DateInterval.Second:
lngDateDiffValue = (long) TS.TotalSeconds;
break;
case DateInterval.Week:
lngDateDiffValue = (long)( TS.Days / 7);
break;
case DateInterval.Year:
lngDateDiffValue = (long)( TS.Days / 365);
break;
}
return (lngDateDiffValue);
}
DateDiff(DateInterval.Day,startdate,endDate)
Hope that helps.
<div class="ForumSig">Regards,
Arun Kumar.A</div>
|
|
|
|
|
Hi Arun
The month, quarter and year calculations in your C# code don't seem very accurate. Can't you just use the VB "DateDiff" function?
Regards
Andy
|
|
|
|
|
andyharman wrote: Can't you just use the VB "DateDiff" function?
Sorry, I do not know much of VB.NET functions,
as I am using C# language.
Any way, thank you very much.
Regards,
Arun Kumar.A
|
|
|
|
|
DateTime.DaysInMonth is the main thing yuo need here.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi, is this what you want to do?
Dim startdate As New Date(2006, 1, 1)
Dim enddate As New Date(2006, 3, 1)
dim s as string
'i just pass the value of startdate & enddate to textbox
txtstartdate=startdate
txtenddate=enddate
'this will calculate the difference of your date
s=DateDiff(DateInterval.Day,strdate,enddate)
Msgbox(s)
is that what you mean dude?sorry if my instinct is wrong.
Don't block the drive way of all the newbies in programming.
|
|
|
|
|
Hello
1) I am making a web page with VB.NET. How to open a pdf-document when clicking a button ?
2) Back-button of explorer does not work after opening my www-page. It only reloads my page again . ?
|
|
|
|
|
1 - just provide a link to the PDF, the browser will open it
2 - the back browser goes back to the last URL, always.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
To open a pdf file in vb.net application use
1. web browser control
and give the code like
webbrowser1.nevigate("PDF File Path")
Hope it will help
- Koolprasad2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
I made the crystal report three days back.It was all-right then... but now more then 70 percent of it's page - where i drag dropped the information part controls and the labels - have got converted into grey(I mean disabled).Now I am not able to change it's controls location(coordinates) which were drag dropped.
Is there any way out for this problem ?
|
|
|
|
|
i'm working with pharmacy appliucation , i had performed the most database and GUI work , excpt the portion of bar code which will read the code from any medicine box and display the item properties like price , expiration date , and so on ..
how can i do that ?
may any help in code please ?
many regards
|
|
|
|
|
You can buy a barcode scanner, but you need to build or buy a database that turns the numbers that a bar code represents, into the details of the product that carries it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
please i need more details..
do you mean that barcode scanner automatically with application to read codes and all i nned here is tp attach this application with my database
regards
|
|
|
|
|
The barcode reader will only scan the code of the product.
You have to interface it with the PC.
You should have a database with columns like
Barcode,ProductName,Cost,Weight and so on.
And create an application that reads the scanned Barcode(from the barcode reader)
and fetch the corresponding properties from the database
and display them in the UI.
Regards,
Arun Kumar.A
|
|
|
|
|
the only stuff you need is barcode reader. just install the barcode reader to the computer then he can read now the code in the box. thats to easy. if you scan the barcode in the box then the barcode reader will paste the code to your textbox or even in notepad.
Don't block the drive way of all the newbies in programming.
|
|
|
|
|
i want to create a function that utilizes a String and does just about the same thing as a Sub,but does not return a value ,can any one help me out?
|
|
|
|
|
A function returns a value, a sub does not. This is another VB disaster, IMO. But, the void return type is a sub. If it's a function, it returns something. Otherwise, there's no difference, AFAIK.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
A function that does the same as a sub ??? I would have thought the solution to be obvious; use a sub
Steve Jowett
|
|
|
|
|
I meant a function that does the same as a sub ,but like all functions do,utilizes an Object or a Component but does not return any value
|
|
|
|
|
Let me make it clear,its something like this
Function str() as String<br />
<br />
'code related with str ,which does something to the form,just like code in an event sub<br />
<br />
RETURN<br />
'I've got nothing to return<br />
<br />
End Function
Say if i choose null as the return value,will the code above it be processed,irrespective of the fact that the function will always return null
|
|
|
|
|
You could do this :-
Function str() as string<br />
<br />
'your code here<br />
<br />
Return Nothing<br />
<br />
End Function
but surely that is the same as :-
Sub str()<br />
<br />
'your code here<br />
<br />
End Sub
Or is it you what to provide an object for the "function" to work with and change, in which case :-
Sub str(ByRef myObject as Object)<br />
<br />
'do something to myObject<br />
<br />
End Sub
This would receive the memory address the the object and change it directly, without the need to passing back the result
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
thanks,i might appear like a newbie,but i'm not,its just that i learned everything by trial and error and my knowledge of the vb lang is here and there
|
|
|
|
|
Vivek Narayanan wrote: i learned everything by trial and error and my knowledge of the vb lang is here and there
I suggest you buy a book and fill in the gaps.
|
|
|
|
|
What you're talking about is still a Sub.
Private Sub SetupDataGridView()
' Code to setup your DGV goes here.
End Sub
Seriously, pickup a book on VB.NET for Beginners. This is really basic stuff you're asking about.
|
|
|
|
|
How should i calulate the no of days in a particular month?
I have a complete datail of the date like the day , month and year.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
