Home All Groups Group Topic Archive Search About

Get Minimum and Maximum date

Author
10 Mar 2006 10:50 AM
itsolutionsfree
Hi All,

i am deep trouble.so,please help me how to get minimum and maximum
dates for particular Month and Year.Any kind of help will help.

for ex: im passing : March 2006

Minimum Date - 01/March/2006
Maximum Date - 31/March/2006

my code:

public sub MinMaxdate(ByVal MonInt as integer,ByVal YeaInt as integer)
Dim MinInt as integer
Dim MaxInt as integer

msgbox "Minimum Date " & "MinInt" & " Of " & MonInt & "/" & YeaInt
msgbox "Maximum Date " & "MaxInt" & " Of " & MonInt & "/" & YeaInt

end sub

With Regards,
IT SolutionsFree

Author
10 Mar 2006 10:59 AM
Larry Lard
itsolutionsf***@gmail.com wrote:
> Hi All,
>
> i am deep trouble.so,please help me how to get minimum and maximum
> dates for particular Month and Year.Any kind of help will help.
>
> for ex: im passing : March 2006
>
> Minimum Date - 01/March/2006
> Maximum Date - 31/March/2006

Dim m as integer = 3   ' month
dim y as integer = 2006  ' year

Dim FirstDate As Date = New DateTime(y, m, 1)
Dim LastDate As Date = FirstDate.AddMonths(1).AddDays(-1)

--
Larry Lard
Replies to group please