Hi,

On my form I have a datetime selector, when I select that it selects the relevant date/time, eg 25/09/2009 14:40:03

Before I save this to the database, I want to get rid of the time part - ie I want to save 25/09/2009 00:00:00

How do I do it?

(Using VB)

If you're saving it as a DateTime column, you can simply use the .Date property, which will save just the date, setting the time to midnight (with DateTime, you'll always have a time... having no time effectively sets the time to midnight).

If you need to format it using a format string, you can always look up DateTime format strings on google. The first two hits will be what you want.

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki �LinkedIn �ForumsBrowser

If you're saving it as a DateTime column, you can simply use the .Date property, which will save just the date, setting the time to midnight (with DateTime, you'll always have a time... having no time effectively sets the time to midnight).

If you need to format it using a format string, you can always look up DateTime format strings on google. The first two hits will be what you want.

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki �LinkedIn �ForumsBrowser