[RESOLVED] Date$

[RonR]

how do I get the current date from the computer?

[RobDog888]

One way...
MessageBox.Show(My.Computer.Clock.LocalTime.ToShortDateString)

Another way...
MessageBox.Show(System.DateTime.Today.ToShortDateString)

[RonR]

Thanks!!!


one related question, if the computers date format is changed, will it change
the formated date from this function?

[RobDog888]

It will eval to whatever the systems regional date/time settings are.

[Hack]

Yes it will. That function just grabs whatever is there.

[RonR]

ok. is there anyway to get the same format no matter what the computer is set to?

[Hack]

You could, however, try something like this if you require a specific format

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text = DateTime.Now.ToString("MM/dd/yyyy")
End Sub

[RobDog888]

You can specify the format if you are worried that the system may use some different format then what you need to calculate with or ??

[RonR]

I am working on a database and I want to add the year to a new record when it is created.

[RobDog888]

Then your tables field's data type should be Date/Time.

[Hack]

Actually, I prefer storing dates as straight text, although I've discovered few agree with me.

Anyway, to retrieve the date, use

DateTime.Today.Year.ToString

[RobDog888]

Yes, I disagree

Also, you mean to retrieve the Year

[Hack]

Give me text or give me death!

My code snippet does return the current year.

[RobDog888]

Anyway, to retrieve the date, use

..

[Hack]

Oh piffle.....he knew what I meant.

[RobDog888]

piffle

Can you read my mind too


Ps, I got the last word in

[RonR]

the length will change.


12/5/2007

1/1/2007

12/12/2007

is string handling the only way to get the year, month, day??

[RobDog888]

Not really. You should just use each function to parse out what you need.

DateTime.Today.Month.ToString()
DateTime.Today.Day.ToString()
DateTime.Today.Year.ToString()

[RonR]

ok, i got it now.


thanks!!!!!!!!!!!!!

[Hack]

If you want the whole date, and not just the year, then wouldn't this work for you?

You could, however, try something like this if you require a specific format

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text = DateTime.Now.ToString("MM/dd/yyyy")
End Sub

[RonR]

yes, I will make an note of that.




this turns out to be what I need:


DateTime.Today.Month.ToString()
DateTime.Today.Day.ToString()
DateTime.Today.Year.ToString()

[Hack]

Just one final thing. I have seen this way too many times. If you are going to be storing the date, or the year, or something along those lines in DB fields, do you call the fields Year or Date or the like. Those are reserved words and should not be used for field names.

[RonR]

I am using: "IncidentYear"

[Hack]

Outstanding. You, potentially, have saved yourself headaches when running queries against your tables.

[RonR]

Yes


no confusion this way