date fields that are not date types

's Computer Specifications

hey all,

i have a number field i need to convert
from
20050818
to
08182005

can someone please show me some ways i can do this?

thanks,
rodchar

's Computer Specifications

Hi,

Date.ParseExact("20050818", "yyyyMMdd", Nothing).ToString("MMddyyyy")

HTH

Roman

"rodchar" <(E-Mail Removed)> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:C5B58584-D892-4D88-A3FB-(E-Mail Removed)...
> hey all,
>
> i have a number field i need to convert
> from
> 20050818
> to
> 08182005
>
> can someone please show me some ways i can do this?
>
> thanks,
> rodchar
>
>

's Computer Specifications

"rodchar" <(E-Mail Removed)> wrote in message
news:C5B58584-D892-4D88-A3FB-(E-Mail Removed)...
> i have a number field i need to convert
> from
> 20050818
> to
> 08182005

Without resorting to nasty Modular mathematics :

i = 20050818

s = i.ToString()
s = s.SubString( 4, 4 ) & s.SubString( 0, 4 )

i = CInt( s ) ' or Convert.ToInt32( s ), whichever you prefer.

Neither of which, of course, are dates - to get those, you'd need :

s = i.ToString()
s = s.SubString( 0, 4 ) _
& "-" & s.SubString( 4, 2 ) _
& "-" & s.SubString( 6, 2 )
d = CDate( s )

HTH,
Phill W.

's Computer Specifications

thanks, this helped.

"rodchar" wrote:

> hey all,
>
> i have a number field i need to convert
> from
> 20050818
> to
> 08182005
>
> can someone please show me some ways i can do this?
>
> thanks,
> rodchar
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent	Mike Saifie	Microsoft Access Form Coding	1	9th Mar 2006 01:08 AM
date fields - link the calander pop-up to a custom date field	=?Utf-8?B?VG9t?=	Microsoft Outlook Form Programming	0	23rd Jan 2006 09:13 PM
Bold face entry date fields that are past the current date.	=?Utf-8?B?ZGNsYXJjcQ==?=	Microsoft Access Database Table Design	4	13th Sep 2005 07:26 AM
Date fields automatically changing when today date matches date field entry.Help!	Brian Cassin	Microsoft Access Forms	1	15th Nov 2003 01:51 PM
Date fields automatically updating when field matches todays date!?! Help!	Brian Cassin	Microsoft Access Forms	1	14th Nov 2003 08:48 PM