DateTime - drop or zero out Time 1

[Hueby]

Hey all, I have done a couple of searches, but haven't found an clear answer....... I am wanting to drop or SET the time values to 00:00:00 .... how do I do this?

  Format(CDate(var1), "MM/dd/yyyy hh:mm:ss")
        Format(CDate(var2), "MM/dd/yyyy hh:mm:ss")

 

[ThatRickGuy]

Like this?

Format(CDate(var1), "MM/dd/yyyy")

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[ThatRickGuy]

or maybe

Format(CDate(var1), "MM/dd/yyyy 00:00:00")

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[Hueby]

Well acutally both of those methods didn't work......

I think I found out that this works though:

var1 = Format((var1), "MM/dd/yyyy")

 

[chrissie1]

I can't see the difference between what rick said and what you say. is var1 a date variable by any chance???

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[Hueby]

The only difference is not using the CDate code, and just using Format. var1 is a date variable yes...

 

[chrissie1]

then that's why you didn't need the cdate. because cdate goes from string to date and to format in the date format you need to feed the format function a date. So ricks methods worked (and he deserves a star for that) you just gave him the wrong information. and he was confused because you already used cdate in your question.

If you want a good answer give a good question.

Thank you.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[Hueby]

Ohhhhhhh.. well that explains a lot then, I didn't even think of the variable coming into play as it did.

You did not have to be so rude about it either.

Thank you.

 

[chiph]

What's wrong with the shared MinValue property of the DateTime class?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[ThatRickGuy]

date.minvalue returns "12:00:00 AM"
format(Now, "MM/dd/yyyy") returns "05/26/2005"
Now.ToShortDateString returns "5/26/2005"

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[chiph]

12am is 00:00:00

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[ThatRickGuy]

12:00:00 AM" != "05/26/2005"

?

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[chiph]

Console.WriteLine(DateTime.MinValue.ToString("d", CultureInfo.InvariantCulture) will return 0001/01/01 00:00:00.00000

Is this not what the OP was wanting?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[ThatRickGuy]

I think his goal was to get:
2005/05/27 17:35:21.12345

to:

2005/05/27 00:00:00.00000

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.