Date Time Function

[Baren]

Hi! I have a requirement, where in I am saving the events based on certain
date seleceted from the drop down values. Onces saved the data is stored in
database. I have calendar control which highlights the date having events and
onclick on the dates it shows the event details. Its working fine on my
system, but when I sending the same to my client (in UK, who use dd/mm/yyyy
format), it showing worng result. eg. If I have a event on 10th April
(04/10/2006), it showing it as a record for 4th of October(10/04/2006).

How to solve the same.. I am using SQL 200 to store the datas and vb.NET for
code behind coding. I am using VB.NET DateTime function to convert the
Dataset column values to date time

Dim dtStartDate As DateTime
dtStartDate = New DateTime
dtStartDate =
Format(Convert.ToDateTime(tblMonthEvents.Rows(intD ayCount).Item("StartDate")), "MM/dd/yyyy")

[OHM \( One Handed Man \)]

You need to check the current culture and use this in your code

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net
"Baren" <Ba***@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...

Hi! I have a requirement, where in I am saving the events based on certain
date seleceted from the drop down values. Onces saved the data is stored
in
database. I have calendar control which highlights the date having events
and
onclick on the dates it shows the event details. Its working fine on my
system, but when I sending the same to my client (in UK, who use
dd/mm/yyyy
format), it showing worng result. eg. If I have a event on 10th April
(04/10/2006), it showing it as a record for 4th of October(10/04/2006).

How to solve the same.. I am using SQL 200 to store the datas and vb.NET
for
code behind coding. I am using VB.NET DateTime function to convert the
Dataset column values to date time

Dim dtStartDate As DateTime
dtStartDate = New DateTime
dtStartDate =
Format(Convert.ToDateTime(tblMonthEvents.Rows(intD ayCount).Item("StartDate")),
"MM/dd/yyyy")

[Baren]

Thanks a Lot..

Regards,
Baren

"OHM ( One Handed Man )" wrote:

You need to check the current culture and use this in your code

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net
"Baren" <Ba***@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...

Hi! I have a requirement, where in I am saving the events based on certain
date seleceted from the drop down values. Onces saved the data is stored
in
database. I have calendar control which highlights the date having events
and
onclick on the dates it shows the event details. Its working fine on my
system, but when I sending the same to my client (in UK, who use
dd/mm/yyyy
format), it showing worng result. eg. If I have a event on 10th April
(04/10/2006), it showing it as a record for 4th of October(10/04/2006).

How to solve the same.. I am using SQL 200 to store the datas and vb.NET
for
code behind coding. I am using VB.NET DateTime function to convert the
Dataset column values to date time

Dim dtStartDate As DateTime
dtStartDate = New DateTime
dtStartDate =
Format(Convert.ToDateTime(tblMonthEvents.Rows(intD ayCount).Item("StartDate")),
"MM/dd/yyyy")

[Hans Kesting]

> Hi! I have a requirement, where in I am saving the events based on certain

date seleceted from the drop down values. Onces saved the data is stored in
database. I have calendar control which highlights the date having events and
onclick on the dates it shows the event details. Its working fine on my
system, but when I sending the same to my client (in UK, who use dd/mm/yyyy
format), it showing worng result. eg. If I have a event on 10th April
(04/10/2006), it showing it as a record for 4th of October(10/04/2006).

How to solve the same.. I am using SQL 200 to store the datas and vb.NET for
code behind coding. I am using VB.NET DateTime function to convert the
Dataset column values to date time

Dim dtStartDate As DateTime
dtStartDate = New DateTime
dtStartDate =
Format(Convert.ToDateTime(tblMonthEvents.Rows(intD ayCount).Item("StartDate")),
"MM/dd/yyyy")

If that "StartDate" column really is a DateTime value (and not a
varchar
that looks like a date), you can use a straight cast to convert it
to a DateTime.

In C# I would use
dtStartDate = (DateTime)tblMonthEvents.Rows[intDayCount]["StartDate"];

Hans Kesting