Char to date?

Van T. Dinh

Guest

Posts: n/a

25th Sep 2003

Use Right(YourCharField, 4)

For example (from AXP Debug window):

?Right("10/12/1975", 4)
1975

HTH
Van T. Dinh
MVP (Access)

>-----Original Message-----
>Hello all,
>I have a char field like: 10/12/1975
>What function to pick out 1975 in VB?
>Thank you for your help
>TM
>.
>

« Create a SQL DSN using VBA | How to create automatic, sequential, customized numbering system »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to permanently delete char char char char style in MS Word?	=?Utf-8?B?Q3Jpcw==?=	Microsoft Word Document Management	6	12th Jun 2011 09:47 PM
Ever seen "Char Char Char Char Char Char1 Char Char Ch" style?	=?Utf-8?B?TWFyaWx5bg==?=	Microsoft Word Document Management	2	4th Oct 2006 04:47 PM
Formatting changed to Char Char Char Char...	=?Utf-8?B?TWVsaXNzYQ==?=	Microsoft Word Document Management	10	14th Apr 2006 07:32 AM
error LNK2019: unresolved external symbol "public: static class ATL::CStringT<char,class StrTraitMFC<char,class ATL::ChTraitsCRT<char> > >	danip	Microsoft VC .NET	0	5th Dec 2005 10:01 AM
Re: Char to date?	Tim Ferguson	Microsoft Access VBA Modules	0	25th Sep 2003 07:06 PM