By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,045 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

formate date field!

P: 22
Hi Mary,
Thanks for ur advise,

i gave this in my code,
MEMBER_END_DATE1 = Format([MEMBER_END_DATE], "mm/dd/yyyy")

but it gives me this error:
Run time error 6: Overflow..

Member_end_date has value 19960101 ,but i get this error how to get around this, pls help!
Mar 19 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,349
Hi Mary,
Thanks for ur advise,

i gave this in my code,
MEMBER_END_DATE1 = Format([MEMBER_END_DATE], "mm/dd/yyyy")

but it gives me this error:
Run time error 6: Overflow..

Member_end_date has value 19960101 ,but i get this error how to get around this, pls help!
Your value is text, the function can't convert it into a date format.
Use:
Expand|Select|Wrap|Line Numbers
  1. Format(CDate(Mid([MEMBER_END_DATE], 5, 2) & "/" & Right([MEMBER_END_DATE], 2) & "/" & Left([MEMBER_END_DATE], 4)
This assumes the middle 2 characters represent the month.
Mar 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.