Convert date string (ie: 1/3/2010) to seriel

's Computer Specifications

How do i convert a date formatted like: 3/8/2010 (string) to its
corresponding seriel?

's Computer Specifications

Use CDate.

? CDate("3/8/2010")
2010.03.08

( In my case, it took the first number as the month; my Regional setting
tell Windows to format my dates in the ISO format, which is year dot month
dot day ).

Vanderghast, Access MVP

"Steve P" <(E-Mail Removed)> wrote in message
news:4CE0A688-FAE5-437C-B1AF-(E-Mail Removed)...
> How do i convert a date formatted like: 3/8/2010 (string) to its
> corresponding seriel?

's Computer Specifications

Van,
Thats exactly what i needed. I just formatted it differently with:

Format([date],"mmddyyyy")

THANKS AGAIN!!!

"vanderghast" wrote:

> Use CDate.
>
> ? CDate("3/8/2010")
> 2010.03.08
>
> ( In my case, it took the first number as the month; my Regional setting
> tell Windows to format my dates in the ISO format, which is year dot month
> dot day ).
>
>
> Vanderghast, Access MVP
>
>
> "Steve P" <(E-Mail Removed)> wrote in message
> news:4CE0A688-FAE5-437C-B1AF-(E-Mail Removed)...
> > How do i convert a date formatted like: 3/8/2010 (string) to its
> > corresponding seriel?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert 24/03/2010 date into 03/24/2010 date format	Nitesh	Microsoft Excel Programming	3	5th Jun 2010 10:44 AM
How to Convert 24/03/2010 as text into 03/24/2010 date format	Nitesh	Microsoft Excel Worksheet Functions	2	5th Jun 2010 10:34 AM
How to convert user-defined custom format date string to date value	abcabcabc	Microsoft VB .NET	1	19th Aug 2005 12:31 PM
Convert a string containing a 32-bit binary date to a date data type	Remi Caron	Microsoft C# .NET	2	22nd Sep 2004 06:23 PM
date add/seriel	dino	Microsoft Access Forms	1	9th Dec 2003 06:29 AM