[AccessD] Need help

Stuart McLachlan stuart at lexacorp.com.pg
Wed Feb 8 21:30:26 CST 2006


On 8 Feb 2006 at 22:20, DorisH3 at aol.com wrote:

> The event number field would look like this 22110906 A....I need to extract
> 110906 and place it into a date field which would be a short date
> 11/09/2006.
> 

Assuming 110906 is mmddyy, the safest way would be
txtEventDate = DateSerial(Val(Right$([Event Number],2)), _
                      Val(Left$([Event Number],2)), _
                      Val(Mid$([Event Number],3,2)))

Then you can format txtEvent as "mm/dd/yy" or any other format you want.
-- 
Stuart





More information about the AccessD mailing list