Date calculations

[hackhack]

Ok, I have DateTime.Now and SomeFutureDate - if I quickly wish to display the difference between now and future as days/hours/months/seconds - is there a quick way to do that I overlooked?

For a brief moment i thought perhaps i could subtract the future long with the current long and do datetime routines on them, but that ended up total nonsense

 

[kanaida]

I know it's wierd dealing with ticks lol

I was trying to make a stopwatch and did this:

Start = DateTime.Now
End = DateTime.Now

TimeTaken = End - Start
???
Profit!

lol

I think you can try: TimeTaken / DateTime.TicksPerDay.
that should give you How many days difference I think.
More than that, there really should be a Date/DateTime Class that handles dates in english.

 

[Erel]

TimeTaken / DateTime.TicksPerDay

The above suggestion is correct.
Make sure to declare the variables holding tick values as longs.

 

[hackhack]

Yeah, but as I said I need days/hours/months/seconds - and i tried it and it didn't work.

 

[Erel]

It should work. If you like you can post your code and we will help you fix it.

 

[hackhack]

Thanks, but I erased it when it didn't work.

However I may redo it later

However, you are saying that one can't use datetime functions to extract day/hour/minute after subtracting the time amount?

 

[Erel]

First make sure to work with Long variables.

You can use those functions with any value. A ticks value represents the number of milliseconds passed since 1/1/1970. I do not know whether it is useful or not in your case.

 

[hackhack]

Also, is it possible to generate a complete time point?

This

DateTime.DateParse("07/07/2011 06:00:00")

Doesn't seem to work, the time is set to 00:00:00

DateTime.DateParse("07/07/2011") + DateTime.TimeParse("06:00:00")

Doesn't work either, the time is 6, but its sometime decades in the future - not surprising since the docs say that timeparse adds "today" to the value returned .

Can one AND out the date value of the timeparse result and OR it with the dateparse result? Or is there another option?

 

[SteveBee]

You should ensure to set the *format* before you attempt to parse:
e.g.

....
Dim DT As Long
DateTime.DateFormat = "yyyy-MM-dd'T'HH:mm:ss"
DT = DateTime.DateParse(Attributes.GetValue(i))
DateTime.DateFormat = "dd-MMM-yyyy HH:mm"
lblSchedStart.Text = DateTime.Date(DT)
....

 

[hackhack]

You should ensure to set the *format* before you attempt to parse:
e.g.

....
Dim DT As Long
DateTime.DateFormat = "yyyy-MM-dd'T'HH:mm:ss"
DT = DateTime.DateParse(Attributes.GetValue(i))
DateTime.DateFormat = "dd-MMM-yyyy HH:mm"
lblSchedStart.Text = DateTime.Date(DT)
....

Wait what, Attributes.GetValue? What's that returning I thought that was related to xml? Or is it just an example?

Also, dateformat can include the time? (Docs didn't say) - that may change things.

 

[SteveBee]

This was just copied/pasted from my code.
Attributes.GetValue(i) is just a value - yes I was parsing xml

If it makes it easier for you:

DT = DateTime.DateParse(strDateTime)

where strDateTime is a string representation of a DT

 

[hackhack]

Hey, I'm just easily confused - thanks for your input

 

[SteveBee]

Hey, I'm just easily confused

join the club, bro'...